Search results

I'm not quite sure what you mean. The existing table I'm trying to append to has relationships with two other tables, the contacts table and the monitoring sites table. The foreign keys that link these tables are the contact_ID and the monitoring_site_ID. Unfortunately since I'm working from the...

I did double check this and the primary key is the only field set to no duplicates, which is why I'm puzzled! I also checked the new table I made and the contact_ID and monitoring_site_ID fields were indexed (duplicates OK). I set these to not indexed and tried running the query again and ran...

Hello! I am fairly new to access and trying to append data from a new table that I created to an existing linked table. I'm working in the front end of a split database. The existing table has one primary key (Plankton_survey_ID) which is an autonumber. It also has two foreign keys (contact_ID...