I hope someone can help me with this… ( I’m very new at base )
As a test, I created two tables, both with a clientID field, consecutive numbers in each field, both set as primary keys,
both field types the same, both field names exactly the same.
When I tried to relate the two tables I get
Can’t create table security
.#sql-19c4_f4
(errno: 150 “Foreign key constraint is incorrectly formed”)
So I deleted the data in both tables and with two empty tables tried to relate the two fields and got the same error message
Thanks
Bob