Hi guys,

I have a a few small niggly problems that i cant seem to tap on the head. If someone could give me any direction or info on how to overcome it that would be great.

1. how do i turn off return all records(applescript maybe or is there a handy script step)

2. when people search for firstname for example i want to make sure that the gender male is only returned do i use contrain ?? what are the steps about getting this working.

has anyone any good examples of a who is logged layout or url to a tutorial i would be very much in your debt.

Thanks D

1. Not sure what you mean. Are you talking about making it impossible to do a

Thanks for the response otter. what happens if the user pushes the apple f key does the code still apply?as there are not using a button predefined by me so i cant stop them from getting females back as well? thanks again

D

what happens if the user pushes the apple f key does the code still apply?

This is something we

You need to set their "Available menu commands," in their Privilege Set, in Accounts & Privileges, to "Editing Only," or "Minimum."

Then their command keys for Find will no longer work; which, in this case, is a good thing. Neither will the keys for New Record. So you have to give them buttons for what they need to do.

If you don't know what the above terms are, you should read about it, at least in the FileMaker Help. It's critical to know for a multi-user situation.

I have a couple of example files in the Sample files specifically on scripting Account creation. I don't know a beginners tutorial about Accounts, but I'm sure there are some. The Help is fairly good. There is a fair amount of intermediate material on the FileMaker site, in the Migration documents; much of it written by Steven Blackwell, who has several posts here, under the user name of "Old Advance Man." I imagine any FileMaker book would have a substantial section about this. Well worth learning.