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.

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

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

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.

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.

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