One does it, the other won't

[customfamily]

Hey guys,

I have an extremely frustration problem.

Four tables:

- Contacts

- Temporary contacts

- Seachlists

They all run through a Join table

People from the temp. contact table and the main contact table are added to the searchlist. They are displayed in a portal. They layout displays data from Searchlist, the portal on it displays data from Temporary contacts. It displays contacts from both tables just fine. Perfect.

Same exact setup for:

-Locations

-Temporary locations

-Searchlists (same as before

And they all run through the Join table.

Again, layout displaying data from searchlist, portal displaying data from temporary locations. But in this case it only displays data from the Temporary locations table, unless I change the portal, in which case it'll only display data from the Locations table. But it won't display both.

WHY is it working fine for contacts but not for locations? I have the EXACT same setup for both. This is so frustratiiiiiiiiiiiiiiiiing :

I'll be glad to provide the file to anybody interested.

Thanks a million guys,

Rob

[Drew Sanderson]

Send me the file and I will have a go at it.

[Lee Smith]

You can attach a file here see this link on the basics Link

[customfamily]

Thanks so much for responding but as I was setting up a demo file for you, I figured it out. Hope you're enjoying your weekend :

Best,

Rob