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.