Results 1 to 2 of 2
Thread: linking table data
2001-02-08, 03:15 #1danprtrGuest
linking table data
The following tables have a common field and I've already linked them using a query. Here is the layout:
Table 1 (1015 records)- BadgeID FName LName ...
Table 2 (1457 records)- BadgeID ActionCode
I just can't get the Query to show the data like my screenshot (edited to show where I want to move the 2 fields).
It seems there should be a way to display records from table 2 in columns along with the records from table 1.
2001-02-08, 04:34 #2
- Join Date
- Jan 2001
- Thanked 0 Times in 0 Posts
Re: linking table data
don,t know if matters but you list the fields as badge id on both tables
in you query you are showing badge id and id(autonumber ?) linked
could this be the problem