Hi,
I'm using a subform to show values of a m:n relation.
Tables and relations:
master master_detail detail
ID(auto)
ID(auto) <-> ID_master
ID_detail <-> ID(auto)
text
The master_detail linking table is shown in a table control on a
subform.
One column of this table control shows the "text" field of the detail
table linked by using a sql-based list field.
No magic involved up to this point.
But now I want to add one more row to the master_detail-table, a new
record in the table control is made, the displayed "text" string for
this one is selected.
When the record is to be stored an error message appears telling that
the field "ID_master" has to have a value (because it's a "NON NULL"
colum).
I will do this by using a little macro retrieving the current ID and
write it to the subforms field, but:
Could this be done without scripting? If yes, how?
TIA,
Marc
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
