Ok, I think i’m using the wrong wording
What I need is a constraint so that an entry cannot be made into Table A until an entry is made in Table B.
Table B has two fields, a PK field and a non-pk field. As soon as I add a relationship from table A to table B, table B gets a new field (FK). That would require table B to have 3 fields, two of which is ever used.
One of the main things is that there will be over 52 different tables referencing Table B. Doing this in toad, will require Table B to have 52 additional fields, all FKs. Even though Table B should only have two fields.
Message was edited by: email@example.com