Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access 2002 training - Linked Databases
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
microsoft access 2002 training - Linked Databases
Resolved · Low Priority · Version Standard
Reply Mon 10 Dec 2007, 14:59Delegate Samantha said...
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
For upcoming training course dates see: Pricing & availability
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
Reply Wed 19 Dec 2007, 10:16Delegate Samantha said...
RE: Linked Databases
Yes the auditor status whether 'active/ inactive etc' will only have one form of response,
|