I have 2 tables with multiple-field primary keys; each record is uniquely identified by both a FarmerID field and a Crop field.
On the form for Table2, I'd like a combo box to show what fertilizer was entered for that record in Table1. I've tried the following code...
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!
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.