G
Golfinray
I have 6 tables. All 6 tables have the arrow and asterisk at the bottom,
meaning they are editable and you can add records. I have autonumber primary
keys and I have indexes on each table on the fields that I am going to join.
Each field that I am going to join is set to long integer. When I go to set
relationships, 3 of the tables won't let me check referential integrity
because it says I don't have unique indexes. If I make queries out of all 6
tables individually, they are all editable (have the arrow and asterisk at
the bottom.) If I bring the 3 tables into the query that have referential
integrity, the arrow and asterisk are there. If I bring any of the 3 tables
into my query that wouldn't let me set referential integrity then the query
is not editable. What do I need to do? Thanks!!!!
meaning they are editable and you can add records. I have autonumber primary
keys and I have indexes on each table on the fields that I am going to join.
Each field that I am going to join is set to long integer. When I go to set
relationships, 3 of the tables won't let me check referential integrity
because it says I don't have unique indexes. If I make queries out of all 6
tables individually, they are all editable (have the arrow and asterisk at
the bottom.) If I bring the 3 tables into the query that have referential
integrity, the arrow and asterisk are there. If I bring any of the 3 tables
into my query that wouldn't let me set referential integrity then the query
is not editable. What do I need to do? Thanks!!!!