Automatic Filling of data from Parent table to Child table field

Friends,
I have a table called salesperson with different fields like salesPID, salesPName etc. Then I have another table sales with a field like salesPID and salesPName.
After creating the relationships and filling in data for the salesperson, I want to automatically have the salesPID and salesPName automatically filled up in the Sales table.
Please do advice me on that.
Thanks in Advance.
Joe

re: Automatic Filling of data from Parent table to Child table field

A subform will auto populate the foreign keys from the primary keys that are linked to it in the main form.