Data corrupt ... Please help

[GDubbs780]

I have an issue ....



Someone (not me I swear) went into a table and started to manipulate the data by changing one of the columns (Customer 1) to a Look Up Field. This has created two challenges for myself:

1) The data is gone ... oops. I can solve this one.

2) More serious, that column (Customer 1) will only display primary key numbers of the data. Before the corruption, I had a combo box on a form. This combo box took its values from a Table called CustomerTable, the value in this combo box was stored in the QuoteListTable. Before it showed names, now only primary key.

I have attempted to:
-change the look-up back to a regular field (got rid of the look-up)
-exported the table to a query, turned it back into a table, no change.

...any help would be great!!!

[GDubbs780]

In addition ...

My ComboBox has some code that in the event the name the user is typing in is not in the list, the user is prompted to add the name to the Customer Table.

In these situations only, the actual name of the Customer shows in the CustomerTable and in the QuoteListTable. However, only the primary key will show in the QuoteList Table if the Customer Name is already present.