6 tables - 2 tables for autofill only in form - how to set up relationships

[jlr123]

Hello. I have 6 tables of which 2 are to be used for autofill in a form and to save the data in the other 4 tables. How do I set up the relationships for the 2 that I do not want to update and what is needed in the form to ensure nothing is changed in the 2 tables. Would those be unbound tables in the form? I have the primary and foreign keys set up in the 4 tables which will include the "autofill" information in the form.
Thanks for your assistance. If you need more info, please let me know.

 

[MajP]

This is not very clear what is going on. My guess of what you are saying, is that you want to store the primary key from the two "reference" tables as a foreign key in your data table/tables. That will create a reference and allow you to display the related information. However if you do this then just lock/disable the controls bound to the fields in the reference table. Normally this is done with a combo box. So assume I have a datatable where I want to assign an employee to a task. I may have an employee table with lots of information about an employee. In the task data table I want to select an employee and store their ID (creating a relation) and then show their information. Normally the foreign key field would use a combox and it would display employee names, but store in the datatable the employee id.

The other way is to use subforms or some combination of these. You would have to explain this a little more

 

[jlr123]

I believe I understand. Thanks for your help. I may be back.