I am having a difficult time getting one Table to Reference to another table, and getting them to link up.
I am constantly getting the Yellow Triangle, indicating that the reference is broken.
But for the life of me, I cannot figure out why.
I am referencing on the FullName Column.
The names are exactly the same in both columns.
My first table is labeled MAIN, and has a FullName column.
My second table is CapGown, and has a FullName column.
I went in the CapGown Table, went to the FullName column, and changed it to ref, and I choose the Main table as the referencing table.
It seems pretty straightforward, but just is not working for me.
What could I possibly be doing wrong?