Hi everyone,
I got a trouble with my form linking, and I right now, I might not see the wood before the trees.
I have a form with three subforms, where each subform refers to a slave table and the mainform to a master table. In the master table, I have a concatenated key which consists of each PK of the slave tables. The form/table is about linking towns to geographic locations and time slices.
So, when I enter a town name in the one form and then trying to switch to the subform to enter location/time, I get an error "Null values not allowed", i.e. Access complains that parts of the concatenated key are still missing (a new entry is created by entering the town name, the town id is inserted into the master table, which is still missing the location/time keys).
In the first run, I simply created dummy values in location and time tables and used them as default values in the master table. Now, of course, Access simply alters the dummy values (since I have used their PKs in the master table), instead of creating new entries in the respective slave tables.
Is there a way to force Access to create new entries in the subtables, once a new value is added to the mastertable? I know how I would do that in VBA, I just had hoped there would be a less time-consuming solution right in the form editor etc. BTW, I'm using Access2000.
Thanks in advance,
Alex
I got a trouble with my form linking, and I right now, I might not see the wood before the trees.
I have a form with three subforms, where each subform refers to a slave table and the mainform to a master table. In the master table, I have a concatenated key which consists of each PK of the slave tables. The form/table is about linking towns to geographic locations and time slices.
So, when I enter a town name in the one form and then trying to switch to the subform to enter location/time, I get an error "Null values not allowed", i.e. Access complains that parts of the concatenated key are still missing (a new entry is created by entering the town name, the town id is inserted into the master table, which is still missing the location/time keys).
In the first run, I simply created dummy values in location and time tables and used them as default values in the master table. Now, of course, Access simply alters the dummy values (since I have used their PKs in the master table), instead of creating new entries in the respective slave tables.
Is there a way to force Access to create new entries in the subtables, once a new value is added to the mastertable? I know how I would do that in VBA, I just had hoped there would be a less time-consuming solution right in the form editor etc. BTW, I'm using Access2000.
Thanks in advance,
Alex
