Hi
I have had some help on this but am getting nowhere!
I have two tables one Information about HGV vehicles the other about accidents that vehicle has had.
I have made two more table, i.e. HGV_History and HGV_Accident_History.
I have made two append queries to move data about any vehicles that have been sold to the history tables. Current vehicles "yes" or "No" is used for this.
When I run the queries as stand alone they move the data. As soon as I build the relationship for referential integrity, cascade, delete I get violations and it will not move the data to one table and delete if from another.
I have checked the tables and eveything is in sync.
Can anyone help I am getting desparate?
I include everything in the tables for these vehicles so in the accident table there could be more than one record for each vehicle.
Is there anything I should leave out or add in to make the move.
I want to keep the same index numbers so do not set the history table to autonumber?
I have set a relationship for the history tables to Referential integrity?
Do I need this or not , or is there more I need?
Help again.
If anyone is willing to look at a short version of what I am trying to do let me know or if you can post details of where you think I am going wrong it will be appreciated.
Regards
I have had some help on this but am getting nowhere!
I have two tables one Information about HGV vehicles the other about accidents that vehicle has had.
I have made two more table, i.e. HGV_History and HGV_Accident_History.
I have made two append queries to move data about any vehicles that have been sold to the history tables. Current vehicles "yes" or "No" is used for this.
When I run the queries as stand alone they move the data. As soon as I build the relationship for referential integrity, cascade, delete I get violations and it will not move the data to one table and delete if from another.
I have checked the tables and eveything is in sync.
Can anyone help I am getting desparate?
I include everything in the tables for these vehicles so in the accident table there could be more than one record for each vehicle.
Is there anything I should leave out or add in to make the move.
I want to keep the same index numbers so do not set the history table to autonumber?
I have set a relationship for the history tables to Referential integrity?
Do I need this or not , or is there more I need?
Help again.
If anyone is willing to look at a short version of what I am trying to do let me know or if you can post details of where you think I am going wrong it will be appreciated.
Regards