By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,401 Members | 928 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,401 IT Pros & Developers. It's quick & easy.

Dynamic Pricing Application

P: n/a
I have a table that includes a base price. The user will use a search
form to finally get to that base price for a particular product.
Here is the part I can't figure out:

I have a table that includes additional options for the item with the
price.
These are in another table called Options.

I was wondering what was the easiest way for the user to select what
options they want and add the total of these additional options To The
BASE PRICE.

I tried to even let the user type in the price inside a text box by
seeing the Options in a subform. But the user can then change some of
the data since the form would have to be in Edit Mode.
I would appreciate any help.

Thanks
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Use a 3 column, multiselect list box. The first column would be hidden and
would have the ID of the option. Columns 2 and 3 would have the description
of the option and the price. You would add the values of column 3 from the
selected rows to the base price.

--
Wayne Morgan
Microsoft Access MVP
"Kenneth Grice" <ke**********@yahoo.com> wrote in message
news:e2**************************@posting.google.c om...
I have a table that includes a base price. The user will use a search
form to finally get to that base price for a particular product.
Here is the part I can't figure out:

I have a table that includes additional options for the item with the
price.
These are in another table called Options.

I was wondering what was the easiest way for the user to select what
options they want and add the total of these additional options To The
BASE PRICE.

I tried to even let the user type in the price inside a text box by
seeing the Options in a subform. But the user can then change some of
the data since the form would have to be in Edit Mode.
I would appreciate any help.

Thanks

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.