I have two tables that are related by the field “Staff_Id”. The first table is the bio-data of all staff while the second is their medical expenses. In the form for the second table, I want a situation whereby if user keyed in the Id number, the corresponding staff name will appear automatically.
I need your assistance please.