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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data entry form has data elements from more than one table

Status
Not open for further replies.

akar33

Programmer
Dec 13, 2004
39
US
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
 
A query or a subform would be the most common ways of showing two tables on one form but I do not see a field by which these tables can be related. How do you see table 1 and table 2 interacting with one another?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top