Simple Relationship Question

[AndyD]

Sorry..

Have a simple relationship/database design question, I sure someone can help.

I have a table that is essentially Read Only and cannot be changed. I need to add another table that has some check box options for the items in the first table.

I want to display all the items in the first table and then be able to check off certain items in the second table against each row in a simple datasheet view that contains both tables.

I have tried searching for answers and have been trying to work out the relationship without luck.

I'm hoping this is simple and i, overlooking something.

Thanks

 

[PaulO]

Build Table2, with at one or more fields corresponding to fields that exist in Table1.Then, create a blank Form and two continuous Subforms into the DETAIL section , one for each table, with Table2_subform (Child) linked to Table1_subform (Master) by the common field. Updates to the Table1 data can then be stored in Table2.