Here is my situation:

Currently I have 2 files.

1. An interface file with one layout

2. A data file with 3 tables. The tables are:

a. Machine shop

b. Glass shop

c. Electric shop

The three shop tables have the same amount of fields, the same field name, and all calculations are the same. The only difference is that they are named differently.

In the Interface file, I have created a layout call shop invoice. I have also created a file reference to the Shop data file containing the 3 shop tables so I can display the table in the 1 interface layout of "invoice".

How can I dynamically change which table shows up in the invoice layout interface?

For example. If I am a user from machine shop priviledge set, than, only the Machine Shop table fields should show up in the Invoice layout. Or if I a user is from a Glass Shop priviledge set, then the Invoice layout shoud pull data from the Glass Shop table, and the same thing with the Electric shop.

The question is prretty much how do you dynamically change the "show records from" in the layout setup part of filemaker.

i think it is better to make three layouts, one for each table it is supposed to display data from. then you can make a script which runs at login which determines the privilege set and sends them to the right layout

IF Get (PrivilegeSet) = glasshop

go to layout "glasshop

etc.

Thanks.

The reason why I do not want to create 3 layouts is because everytime I make changes to 1 layout. I have to re-apply to the other three. It can get pretty nasty if we have 20 layouts per shop. But we want all 3 shops to utilize 20 layouts only because they are the same, instead of creating 60 layouts for these 3 shops.