Showing only one record in Detail form (many to many relationship) [message #659645] |
Wed, 25 January 2017 11:38 |
|
IneedYourHelp
Messages: 27 Registered: January 2017
|
Junior Member |
|
|
Hi
I have three tables: table A, and B as main tables and AB as my cross-reference table. A is the master form of AB and AB is the Master Form of B. When i click on a record in A it shows all the records in AB which reference to the record in A, but in table B it only shows the depending record to the first record in AB and not to all of them.
How can I show all the dependent records in B?
Thanks!
|
|
|
|
|
|
Re: Showing only one record in Detail form (many to many relationship) [message #659655 is a reply to message #659654] |
Thu, 26 January 2017 06:41 |
|
IneedYourHelp
Messages: 27 Registered: January 2017
|
Junior Member |
|
|
Thanks for your help!
@cookiemonster My problem is that I have two relationships. I select one record in the first master table A and it shows many records in the child table B. This child table B is a master table to another table C, which does not show all correspondend records to all the records in B which are displayed because of selecting a record in A.
@Littlefoot Do you have any idea what exactly I have to modify?
Thanks in advance.
[Updated on: Thu, 26 January 2017 06:42] Report message to a moderator
|
|
|
|
|
|
|
Re: Showing only one record in Detail form (many to many relationship) [message #659686 is a reply to message #659684] |
Fri, 27 January 2017 06:17 |
cookiemonster
Messages: 13925 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Do you want to skip having the block on B?
If not then you have to live with it, your requirement is non-standard and forms doesn't work that way.
Otherwise there are options:
1) Create a view that joins B and C and base the block on that so you can link it to A.
2) Base the block on a procedure that gets all the C records that correspond to the A record.
3) Do the join manually.
|
|
|