• linking table data

    Author
    Topic
    #1768171

    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.

    Viewing 0 reply threads
    Author
    Replies
    • #1777959

      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

    Viewing 0 reply threads
    Reply To: linking table data

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: