| Master - Detail - Grand detail relation in forms 6i [message #496106] |
Thu, 24 February 2011 09:01 |
dornalpr
Messages: 8
Registered: October 2010
|
Junior Member |
|
|
Hi All
I have 3 tables.
Table 1 is header table where Col1 is primary key.
Table 2 is detail table of Table 1,
Col1 is foreign key - references Table 1,
Col1 & Col2 is composite primary key
Table 3 is detail table of Table 2,
Col1 & Col2 combination is foreign key - references Table 2
I have made 3 blocks
Block1 :
Table 1 (record A)
Block2:
Table 2 (details of record A)
Block3:
Table 3 (details of record (A) in table2)
in a form and made the relationships accordingly for above tables.
When i query records in trhat form, first it is querying properly.
After querying by F7 - F8, if i click on Block2, it shows the detail records in Block3.
If i directly go to 2nd record in block2, it is clearing both block2 & block3 and not showing any records.
I did debug all ways, bot could not succeded.
Please let me know where am i going worng.
Thanks in advance.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
