Struggling! Please help!

Jun 12, 2012
Reaction score
I'm a beginner at Access and I can't seem to find the correct answer on any other forum online.

I have a Call Report form that fills in three tables - Company Register (fills in the Company Name), Contact Register (fills in all of the contact details of the person from the call report) and the Call Report table itself, which comprises things like the date, time etc. The issue I'm having is when there are multiple Call Reports completed for the same company eg. Rio Tinto. Instead of the Company Register filling in Rio Tinto once (say under Company ID - this is the primary key and an autonumber), it does it twice giving it the Company IDs 1 and 2. How to I get Access to identify that Rio Tinto already exists and just have it with the unique identifier?

The Company ID table is linked to the Contact Register which is in turn linked to the Call Report table.

Thanks in advance

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question