AnsweredAssumed Answered

A little clarity please on table relationships

Question asked by BillPlunkett on Dec 13, 2013
Latest reply on Dec 13, 2013 by BillPlunkett

Title

A little clarity please on table relationships

Post

     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.

     Why?

     thanks,

      

      

      

Outcomes