Fixing a related problem

[superrob5]

I have a table calle PurchaseReq
PurchaseID
User Name

For now I have been having the user name being type in manual but now i want to change it so it is linked to a table and the autonumber from that table gets inputed instead of the name so it related corectly.


How do I fix this?

 

[FoFa]

Create a foreign key in your table.
Create a query to populate the foreign key from a join on name (boy is that frought with disaster).
Any forms use a combobox/listbox to select the employee and populate the foreign key going forward.
Remove the NAME field from your table when all rows have been populated.