I am trying to create a table (or form) where I pull data from a seperate table and if I fill in the 2nd field, the 1st field fills in automatically, or if I fill in the 1st field, the 2nd fills in. The 2 fields are a number and its name; where each are unique. I am sure I have done this before with either a table or form but can not get it to work now. Thank you in advance.