I am creating a portal of possible images to use for each parent record, but am having trouble figuring out how to best create the relationship so the portal records are always available regardless of what the parent record is. What I am considering doing (hoping I'm missing something) is to create…

So you want all records in the related table ( the images ) to be available to the parent record? Change the relationship from = to x. It may be better to make a picker, depending on what you are doing.

You can une the X relationship predicate operator (instead of =), and point that to any non empty field (like your table ID). That would make the portal show all records, regardless of the parent you are on. If you want a specific set, I would bring the criteria in a global field in your parent rec…

Yep, @jormond gives great advice and is very dedicated to the product. Once again, I'm blown away with the terrific app I created so powerful and quickly using FileMaker! Thanks again.

It's hard to beat @jormond to be the first one to answer around here... I'll need to ask him what type of notifications he is using lol...

[image] Bobino: It's hard to beat @jormond to be the first one to answer around here... I'll need to ask him what type of notifications he is using lol... Hope that never stops you from replying, though. I always appreciate seeing the replies from either/both of you.

Completely agree. Most of the time, it's just a coincidence. I just happen to be looking for something just as this was posted. I'm also open to slowing my replies so it gives others more time to reply. I wouldn't want to stunt other's participation in any way.

I always use a calculated c1-field instead of a x-relationship (each table has a field with just =1 as a calculation) In the database relationship graph, it is for me more clear than a x-relationship [image]

I agree. That’s what I did initially.. In an enterprise database you would never (intentionally) create a Cartesian product (in FMP, an “x” relationship) with more than just a few rows. Thanks

Global Portal?

Questions

Bobino September 3, 2020, 5:29pm 8

That is all good, I just need to work on my "coincidences" a bit better... And make shorter replies

Communication & Perception

Topic		Replies	Views
How to join to "all" Floating Topics join	10	382	December 1, 2022
Relationships between records in the same table Questions community	19	1687	December 3, 2019
Filter using Relationship vs. Portal Filter Questions calculations	5	1341	October 1, 2021
Portal Filter Another Portal? Questions layout-design	2	341	September 27, 2022
How to not show a data entry portal row Questions relationships , hide-when , record-creation	11	664	May 20, 2021

Global Portal?

Related topics