View Single Post
Old 03-22-2009, 02:04 PM   #2 (permalink)
kmote
 

Join Date: Jul 2005

Location: England

Posts: 2,179

kmote has a spectacular aura aboutkmote has a spectacular aura about

Default Re: Microsoft Access Inquiry

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.
__________________
MSI P43 Neo|Enermax Pro82+ 425W|E5200|silent 8500GT|250GB Samsung spinpoint F1|Samsung SATA DVD RW|4GB Corsair|Antec SOLO|openSUSE11


There are in order of increasing severity: lies, darn lies, statistics, and computer benchmarks. - diskinfo man page
kmote is offline