If you've got two layouts in one table, can you restrict which records are shown by each layout? I know I can write a script that shows only certain records based on field contents, but can I make it work in such a way that the user doesn't have to run the script? I just want Layout A to show X records and Layout B to show Y records, all in the same table. Is this possible?

Thanks!

Tom

Hello, hellohelp:

Create a global text field gFilter

Now create a new TO for your table in the relational graph, lets call it 'TableFilter', and connect it to your first one gFilter=RecordType

Now, create a new layout based on TableFilter with a portal to your original table.

Type "X" into gFilter, and only your records with "X" in the RecordType field will display. Now type "Y"...

The exact specifics depend on your workflow and other details, but basically, you will be doing all of your interaction through related fields or portals. It might seem a bit wierd at first, but it is very easy to do, and offers many advantages.

-Raz

Thank you very much!

It worked like a charm!