Ok I have got the primary keys to take duplicates. I just add an ID field and also made that a primary key.

Now when I try to make relationships between tables I get an error saying Data in TableMachineMaintenance violates referential integrity rules. Something about editing the data in the records so that records in the primary table exist for all related records.

any ideas?

aja