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!

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

Inserting lookup field in form 1

Status
Not open for further replies.

davidbenz

Technical User
May 30, 2001
2
EC
I'm creating a form based on two tables that are linked by an ID number. I'd like to be able to type in an ID number for table A, and see data from table B displayed for the corresponding ID number. Is there an easy way to do this? Thanks!
 
David:

Is Table A related to Table be as one to many?

If so, reate a form based on table A. Add a combo box to look up records on your form based on ID.

Create a second form based on table B using either datasheet or continuous form style and insert it into the form for table A as a subform linked on ID.

This should be all you need.
Larry De Laruelle
larry1de@yahoo.com

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top