2 portals to same db for different records

[EasyEdE]

I have two related databases - A and B. A layout in A has two portals (X and Y) to B based on the same relationship link. I want the records in B to appear in one or the other of portals X and Y base on the contents of Field K (a Yes/No value list) in B.

I tried to create different links for Protals X and Y by concatenating the basic link between the two files with the result of Field K but that isn't working.

Any suggestion on how this might be done will be greatly appreciated.

[Vaughan]

You're going to need two relationships, one for each portal.

[EasyEdE]

Thanks for the fast response. I've been working on the "two links" approach for a little while this PM but don't quite have it working right. I'll give it a rest, take a nice shower and hope an insight as to the glitch comes to me. I suspect the problem may be in the way I set up the two additional links between A and B. At least you confirmed that I'm headed in the right direction.

Thanks,

Ed

[EasyEdE]

I took a nice refreshing shower and thought I had the answer as outlined below, but it doesn't work!

I have two related databases - A and B. For general use A is linked to B (A is one, B is many) using a field named Link in both A and B. A layout in A has two portals (X and Y) to B. I want the records in B to appear in one or the other of portals X and Y based on the contents of Field K (a Yes/No value list) in B.

I have created 2 new links FROM A TO B. The key for the portal where the records from B with Field K = "No" are to appear is equal to [Link & "No"] - brackets not included - and is called LinkNo. The key for the portal where the records from B with Field K = "Yes" are to appear is equal to [Link & "Yes"] and is call LinkYes. I also created a new key in B that is equal to [Link & Field K] called LinkYesNo. While the links in A are "constant" the value of LinkYesNo will vary depending on the selection of "Yes" or "No" in the value list from Field K.

The relationships are

For Portal X (where Field K = "No" )

Db A LinkNo = :LinkYesNo Db B

For Portal Y (where Field K = "Yes")

Db A LinkYes = :LinkYesNo Db B

Both portals are defined with their respective relationship and all all fields in each portal match the portal's relationship. Bottom line - it does not work!?!?!? All records in B show up in BOTH portals even though Db B Field K equals "Yes" in some cases and "No" in others.

TIA for any feedback.

[Vaughan]

You have the right idea... only create two calculation fields in B to act as the key fields: one calc displays a value if K=yes, the other displays a value of K=no.

In A, point the relationships to their respectve key fields in B.

[EasyEdE]

Vaughan,

Many thanks - it works like a charm. It is both challenging and frustrating to find that you are so close to a solution is yet so far!!

Regards,

Ed