Results 1 to 2 of 2
  1. #1
    danprtr
    Guest

    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.

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Tennessee
    Posts
    194
    Thanks
    0
    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
    JerryC

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •