Main form and nested Subforms

[tatlikiz13]

Hi,

I have problem with my nested subforms. The first subform does coordinate with the main form but the second subform doesn't coordinate with the first subform.

Although the linked fields are correct he doesn't show me all the results in the second subform.

All these forms are based on queries but When I execute the query it also doesn't give me all results

I don't know what to do

Can someone help me with this

thank you

 

[danvlas]

"the linked fields are correct"

Are they?

How did you set them up?

Is it a One-To-Many-To-Many form?

I guess you have to 'carry' the primary key from the first subform to the main form. Then use it in LinkMasterFields property of the 2 nd subform...

Just a thought...



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[tatlikiz13]

It seems that the links between my tables weren't correctly set. I had a 1to1 relation but...

My parameter tabel is linked with the parameter_id key with the two other tables Formule1 and Formule2.
These tables (Formule1 & Formule2) don't contain all the records that occur in the Parameter table.

So the problem was in the relationship settings ==> The jointype was wrong.

Thanks for your respond danvlas

I have another question, is it possible to convert a report to XML and if so how can I do it?

 

[sandylou]

how do you set up the one to many relationship join in the subForm?

 

[tatlikiz13]

I don't think you can do this on a main form or subform. I have set up this property by my tables and I've linked these tables with 1tomany jointypes.