When making non-identifying FK references, and using a standard ‘ID’ name in tables, the ‘ID’ FK reference shows up as a duplicate ID. Since this is guaranteed to be an error, why not just default it to: tablename_FKname, which will amount to: tablename_ID when ID is the usual PK name? This is a common convention and would save a lot of time.
Message was edited by: Olivercomputing
Message was edited by: Olivercomputing