Hello

Filemaker "Perform find" behaves different when limiting "View" access on a table, than limiting "Edit" access.

When I limit "View" access on a table the following happens:

I use a script to "Perform find". I use some field from the table, and use a "*"(actually it doesnÄt matter) for search critaria.

Result "nothing found" + Quickfind isn't working either

When I limit "Edit" access on a table the following happens:

The search works just fine.

Any ideas?

If in a script you're not using the build requests, then start like this

Enter Findmode

omit record

Set field [nn,$theValue]

Perform Find

The second line does the same as manually checking the box in the status area...

--sd

Filemaker "Perform find" behaves different when limiting "View" access on a table, than limiting "Edit" access.

Shouldn't it?

@Søren Dyhr

God ******* it, that was it. I was about to smashing something here.

The omit option : thanks a lot.

@comment

Well, no. In my opinion it is not intuitive.

1. Next question. How do I make Quickfind work?

2. Now I can hide all <noaccess> record, but the user still cannot use the search STRG+f. What to do ?

I also noticed, when I take the file of the Server and start it locally, then everything works just fine.

I am not sure I understand the issue here. Records that users are not permitted to VIEW are automatically omitted when you perform ANY find - see, for example:

http://fmforums.com/forum/index.php/topic/74827-data-reduction-based-on-privilege-set

Records for which users DO have have view permissions will of course be found - regardless of edit permissions.

There should be no difference between the results of Søren's script and say:

Perform Find [ Specified Find Requests: Find Records; Criteria: YourTable::AnyField: “*” ] [ Restore ]