Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lookup Two Fields

Status
Not open for further replies.
tczultan

tczultan

Technical User
Nov 11, 2002
7
US
Hello!

I am trying to use a lookup field to collect two pieces of data into the form.

For example, In the "products" table/form I have a product name and a price. In the "Orders" table/form, I inserted a lookup field that consists of the Name and Price fields. How can I have the price insert automatically corresponding to the product selected?

Thanks,
Tony
 
Status
Not open for further replies.

Similar threads

BugZap13
  • Locked
  • Question
How to extract Access table schema with decimal places on numeric fields?
Replies
2
Views
2K
dhookom
dhookom
Lidias13
  • Locked
  • Question
Odata contains fields from multiple tables in single table with different field names - for same
Replies
1
Views
319
dhookom
dhookom
HebieBug
  • Locked
  • Question
Lookup field in a table will not allow me to use auto expand 1
Replies
2
Views
172
HebieBug
HebieBug
MattGreer
  • Locked
  • Question
Is it "bad" to have a Lookup table/query in a table? 2
Replies
4
Views
150
MattGreer
MattGreer
BLSguy
  • Locked
  • Question
Referencing Totals from One Table in the Fields of Another
Replies
2
Views
117
BLSguy
BLSguy

Part and Inventory Search

Sponsor

Back
Top