A little clarity please on table relationships
This really isn't a problem to solve, just a "why does it work this way" question.
I have a table for contacts (which includes vendors). I have a Ledger Transaction table and a Fixed Asset Table, both of which have a foreign key field to the contact table - which is the vendor the item was purchased from.
I have a 1-to-1 relationship from the Fixed Asset table to the Contact table but when I attempt to place the same relationship from the Ledger to the contact table it says I must create a new occurrence of the contact table.