Question duplicate records

Hi there,

I have now completed my database.

However I realised there is a potential flaw with it that needs rectifiying.

How do I tweak my database to allow for:-

- if a driver leaves I retain his records but can assign his call sign i.e. 01 or 02 to a new driver that joins whilst keeping hold of previous information stored for the old driver against that call sign?

- 1 driver may have 2 vehicles, how can I tell MS access which vehicle is activate but still retain historic records for previous vehicles that driver has owned?

your comments would be appreciated

thanks

xirokx said:

- if a driver leaves I retain his records but can assign his call sign i.e. 01 or 02 to a new driver that joins whilst keeping hold of previous information stored for the old driver against that call sign?

Click to expand...

Is is all in how use use the call sign. I would have a call sign (master list) table. Use a junction table (tblDriveCallSign) to relate the call sign to drives. This will also give you a history of call sign assignments.

Junction table example:

xirokx said:

- 1 driver may have 2 vehicles, how can I tell MS access which vehicle is activate but still retain historic records for previous vehicles that driver has owned?

Click to expand...

Use a junction table to relate the driver to a vehicle. The same principle will able to drivers and vehicles as did with drives to call signs.

Junction table example:

i love you

you rock

thank you very much

You're welcome!

Glad we could assist.