Can't setup Referential Integrity
I created a DB with two tables: Property table propID autonumber primary key address short text city short text state short text Residents table ...
Forum Discussion
Your post shows that the field called propID in the Residents table is a "large number". Large Number is a different data type from "Long Integer". The AutoNumber propID in the Property table is a Long Integer, not a Large Number. Change the datatype to Long Integer for that field in the Residents table.
George_Hepworth Thanks. Yes, I know that the indexes are long integer but I haven't run into this "Large Number" so I took a guess---wrongly.
Thanks much.
Larry Woods
lwoodsusa I'm glad you were able to sort it out.
The Large Number datatype was added for compatibility with SQL Server's BigInt datatype. If you have not worked with a SQL Server back end, though, it might not have been something you'd take note of.
- Right you are. I come from the underworld of open software and (disgusting, I know) "MySQL!" 😉
Thanks, again.
