Database with information that defaults depending on the data entr

  • Thread starter Thread starter Marie
  • Start date Start date
M

Marie

I have a database that is designed to track customer requests. I would like
for the user to be able to enter a value in a form and have it default values
into a table. If a customer requests "Z" product the charge will be $5.00
$5.00 $10.00 $25.00 $100.00 depending on the size. The values are set
values that need to populate the cells in a table. In other words all the
user would have to enter is "Z" and the prices would self populate, or "R"
for a different product and have it self populate. I only have 5 products I
need to do this for but am having a difficult time trying to do it.
 
I have a database that is designed to track customer requests. I would like
for the user to be able to enter a value in a form and have it default values
into a table. If a customer requests "Z" product the charge will be $5.00 
$5.00  $10.00  $25.00  $100.00 depending on the size. The values are set
values that need to populate the cells in a table. In other words all the
user would have to enter is "Z" and the prices would self populate, or "R"
for a different product and have it self populate. I only have 5 productsI
need to do this for but am having a difficult time trying to do it.
Click to expand...

cascading comboboxes will do this:
http://www.mvps.org/access/forms/frm0028.htm
 
In your products table, why don't you enter each product and its size as a
single product and in the price column enter the appropriate price and once
say product Z small is select, $5 becomes the price or if Z medium is
selected $10 becomes the price automatically.

Or you could have a size table with a one to many relationship with the
product table and have a price column in the size table.

Just some thughts.
 
Back
Top