I need to have a field pre-populated with a dollar amount associated with a product chosen. Example - in one field you will pick "lettuce" from the drop down and the $ amount of lettuce from the lookup table will pre-populate. How can I do this? I am at a roadblock!
2007-01-23 04:46:36 · 2 answers · asked by Fatherof2 1 in Computers & Internet ➔ Programming & Design
Use a QUERY to associate the dollar values with the items, and make a FORM based on the QUERY
2007-01-23 04:50:46 · answer #1 · answered by Richard H 7 · 0⤊ 0⤋
It sounds like you need a relational database design. Once the design is right, figuring out the pre-population shouldnt be bad.
You need one table that has ItemName(lettuce),Price($0.28) and another table that makes sense to have lettuce in it... like order or whatever. Just make sure that there is a 1 to many relationship between the item table, and the order table (or line item if it is broken down that way) Many orders (or line items)may contain lettuce, that has a price entered once...
The pre populating issue is probably easy once the structure is set up the right way.
Hope this helps
2007-01-23 13:07:21 · answer #2 · answered by Mike K 4 · 0⤊ 0⤋