AnsweredAssumed Answered

Relational Fields

Question asked by copesetic on Oct 3, 2012
Latest reply on Oct 4, 2012 by copesetic


Relational Fields


     I am having a problem with a foreign key field.  I have a table that will have 3 separate customers on it.  I am trying to pull the data from my customer table using the the foreign key field on my main table.  The problem that I am having is I can't get the 3 different fields to use the customer table individually, when I change one they all change to the same selection.  I feel like I should be able to have different fields on my table reference the customer table with different entries but I can't seem to get it to work.  Anyone have any solutions?  Thanks in advance.