Well, if I understand your question properly then the answer should be yes.
Master( ID, Val1...) Master_Detail( ID, MasterID, Val2....) Detail( ID, MasterID, MasterDetailID, Text.....) 1) You can link a sub form to its immediate master on more then one field. 2) You can have fields in your sub_forms dataform control that are not displayed. So, just carry your MasterID all the way down to your detail sub_sub_form and link on both MasterID and MasterDetailID. That should do it. On 9/22/07, Marc Santhoff <[EMAIL PROTECTED]> wrote: > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
