I am new to Access and trying to create a DB for a client that is in the trucking industry. Before I get ahead of my self I was wondering if you could view my relationships and make sure they are going to accomplish what I am after.
First I created this with a template so the error on open 'The form name 'Project List' etc... how can I find this and delete the reference.
Rules of the DB:
An Invoice can only have 1 pickup location and 1 customer
An Invoice can have multiple drop off locations and AccessCharges
A dropoff location can have only have 1 driver and 1 truck
I am sure there are other aspects I have not thought of and your comments are greatly appreciated.