Samantha has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Linked Databases
I have linked a table from a (seperate) database (using a link). i want to run a query so i can get both tables to link up (using ID number). It is an 'Employee' table and i want to add the 'auditor status' from another database i thought i could get the two to work together. I have the two tables in one database but can't seem to join (link) them please can you help? Both tables can be opened from the same database but i can't connect them together
RE: Linked Databases
Hi Samantha
thank you for your question. Can I check regarding your data - from the table names it looks like the relationship between your fields would be that an employee would have one auditor status and that this status would be a form of category (that could be set to describe the audit status of that employee). Would that be correct?
Kind regards,
Andrew
