Form Field to Populate into Table

[ajhts]

I have another linking field issue. This does not involve calculations. I have a data entry query to speed up the process. When they enter the facility number, the facility name automatically pops up in the next field labeled facility name.

What I need is for the facility name to go with the rest of the data to the master table. It never does and I know that it needs to be child linked or something like that. Can you please help me!

Thanks,
AJ