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!
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.