I hope I am posting this in the correct area.

I am a novice and have just built my first application for my business.

We have built an application where all our prospects, customers and Infrastructure sites are in one table. I want to have 4 buttons at the top of a screen where you can select which data you want to work with, Sales, Customers, Infrastructure or All. So, when you press the "Customers" button you only see customer records even if you add, delete or find, only when you press the ALL button will you see all records. (the table does have a record type field).

Is there a simple way to do this. Everything I have tried cancels when you do a find. I don't mind if the only way is to have different layouts for each function if that could do it.

Thanks

Adamb

You can force the user to use scripted finds only, and add the criteria before performing the find. Or use a script trigger to constrain the found set when entering Browse mode.

thanks for the suggestions.

I have used script triggers, however how would I "constrain the found set when entering Browse mode"?

thanks

Adam

Use a script triggered OnModeEnter. Enable the trigger in Browse mode only.

Use a script triggered OnModeEnter. Enable the trigger in Browse mode only.

Sorry you have lost me here. What would the script do? And if I enabled it in Browse mode only, will users be able to find withing the original found set?

how would I "constrain the found set when entering Browse mode"?

Use a script triggered OnModeEnter. Enable the trigger in Browse mode only.

What would the script do?

Constrain the found set. For example, user have searched for "Smith" and found 3 of them. This triggers the script that constrains the found set to "Customer" only.

On second thought, it will be easier to trigger the script on exiting Find mode.

I am afraid you have lost me. I will get out my book and see if I can figure this one out.

I am afraid you have lost me. I will get out my book and see if I can figure this one out.

Check out the filemaker white paper on script triggers.

http://developer.filemaker.com/content/technet/pdf/script_triggers_en.pdf