Microsoft Access Inquiry

[alehkcis]

i would like some help from some experts in SQL im using microsoft access to get an external report, i have 2 tables which is named "Person Table" and "Badge Table" now on the person table there are 3 columns that i want to get which is first name, last name and employee number. on the badge table i want to get the encoded number. when i try to create a report either it wouldnt generate any data or the data is not synchronized, meaning the encoded number is not for the intended person.

 

[kmote]

You need a reference on one of the tables. Since you have two tables I assume there is a one person to many badge relationship in which case you should add a employee_id field to your badge table and use that to reference the employee record.