When I enter data into the form and execute the dropdowns to choose the data for these fields all goes well until I look at the view for that table.  In two of the lookup fields the data only appears in one record of the several records in the table.  Then if I create a new record the data in the record that shows data in the two lookup fields actually moves to the new record and leaves the other record blank in those two fields.  What is going on?