I have a table A that has a one to many relationship with Table B. Most of the time there is no data in B. If I create an update query linking A with B with say 100 records all of the check boxes are greyed out and are not updateable because there is no corresponding data in table B to link the two tables.
What I am trying to do is update all 100 records in the update query. So how do you force the linking field to always have the link field in table B when no data has been entered in it.
Basically I want the link field always created in table B when a record is created in table A.
I access Table B via a pop up form. In this form are check boxes that automatically add data such as today's date.
I do input data into table A via a form and I could force the pop up form for B to be visible/invisible and then just set the link field from the link field in form A. It just seems a crude way to do it.