I have a portal to another DB, but I only want to show the records where anotherDB.Status="live".

How do I do that?

Thanks,

Martin

Create a text field in your first db with auto-entry "live" or create a text calculation field with "live" as its result. (Better yet, create a global text field, if you want the ability to switch easily between viewing "live" and "not so live" records.)

Assuming anotherDB.Status is an indexable field, create a relationship from the first db to anotherDB, matching the newly created field to Status in anotherDB.

If you choose the global option, then put it on the layout and format it as a pop-up menu, using a value list containing "live" and "dead" as its values. Now when you click on the field and change it from one to the other, your found set will reflect the status you've selected in the global. If you don't need this feature, then at least you have the idea in case you need to use it in the future.

Happy programming!

Thanks for your very quick reply.

I just realized there might be a slight problem. In another layout in the same database I am using another relationship between the same two databases to show all matching records, which means all records are showing...

Do you have any idea of a workaround for that?

Thanks,

You can use as many different relationships as you want to, even on the same layout, and they won't step on each other's toes. Even if you are viewing all records in the current file, you can use portals to only show the particular information based on the relationships to other files that you want to see at that time. Portals are magical like that!