Save Linked tables values in form based table

[mls via AccessMonster.com]

I am planning to have main form and sub form architecture. In my main form(
linked table to foreign database) I have ID and demographic values and this
main form is connected to a subform by ID and has test details.

My question is How can I save the demographic data into my sub-form based
table?
I know it is bad normalization but need to have all the data related to my id
stored in my table ( it will very few so not worried about re-dundancy.

Thanks

 

[Arvin Meyer [MVP]]

You never need to be redundant. A query with a join on the ID field will
always show the data from both tables.

 

[Guest]

I am planning to have main form and sub form architecture. In my main
form(
linked table to foreign database) I have ID and demographic values and
this
main form is connected to a subform by ID and has test details.

My question is How can I save the demographic data into my sub-form based
table?
I know it is bad normalization but need to have all the data related to my
id
stored in my table ( it will very few so not worried about re-dundancy.

Thanks