Recent content by BeeGeesus

I have attached a zip file of the relevant part of my database. I thought I was making it easier by using Driver Name as the common key, but maybe this is wrong !!!!! Also this is in Access 2007 format. Have I over complicated the data base by splitting the tables into Driver Name (Lookup...

Sorry I didnt explain myself properly. The database is too keep a record of people, vehicles and numbers. When we take on a new customer the unique details like name and vehicle are used as the PK. The start form contains the FK. I want to add new PK's to the relevant tables without the...

I have designed a form providing information for several tables where the primary keys are used as a lookup. I keep running into the violation issue. I am looking for a way to copy a value to the primary table and then continue with data entry using the form or to bypass the referential...