I have data entry screen which has data fields from different tables, I am very limited with my access so please help
Table 1
Name
ID
Tag
Table 2
City
State
Zip
the form needs to have data form both the tables in the same screen.
Name, ID, Tag, City, State and Zip but the field list lets me choose only one table
Table 1
Name
ID
Tag
Table 2
City
State
Zip
the form needs to have data form both the tables in the same screen.
Name, ID, Tag, City, State and Zip but the field list lets me choose only one table