I have a lookup form where I enter a lookup value, Let us say 16, from a combo box
On entering 16, 7 other text boxes populate showing me the information I need to see.
The problem I have is one of the fields is SupplierID_Fk which is a number representation of 7. I would like to see the supplier's name instead of the foreign key number. Can I insert another text box that links the FK to the Supplier table to show the supplier name?