Place saved finds on a layout
Is their a way to put saved finds(new feature with ver 10) on a layout? I am using FM Pro 10 adv.
I assume you mean you want to see the list of currently saved finds on the layout instead of in a sub menu of the Records menu?
Not as far as I know. But there are ways to save either the criteria used or a list of the found record's serial numbers in a table and then you can list those records on your layout or in a portal.
If you have something different in mind, please elaborate.
"But there are ways to save either the criteria used or a list of the found record's serial numbers in a table and then you can list those records on your layout or in a portal."
Basically I have about 3 customers that I do a lot of work for and would like to list them in a portal as you mentioned and be able to go and see there list of orders.
Define a table for listing any such customers. You may already have a table that lists all customers--including the three you wan to see in your portal. If you don't have a table, define one. If you have the second situation, add a field, Selected, to this table and format it with a single value check box so that you can designate specific customers to be listed in your portal.
With either table, you should have at least two fields defined in your customers table, CustomerID--auto-entered serial number and CustomerName.
You can use this relationship:
YourTable::AnyField X Customer::CustomerID
X is an operator to use in place of = when you want all records in one table to match to all records in the other.
Now place a portal to Customer on your layout for YourTable. If you added the Selected box to an existing customer table, define a portal filter that only allows customer records with a value in the selected field to be displayed such as: Not IsEmpty ( Customer::Selected )
Use a script similar to this to find your records:
Set Variable [$CustID ; Customers::CustomerID ]Enter Find Mode  // clear pause check box.Set field [YourTable::CustomerID ; $CustID ]Set Error Capture [on] //keeps dialog from interrupting script if no records are foundPerform Find 
You may need to modify this approach and the above script if the records in YourTable do not include a CustomerID field.
Thanks for the reply this is some good stuff. So basically you would apply Not IsEmpty in the calculation area for this particular field...so that it only displays just those records.
In Portal Setup (FileMaker 11 only)
Select the portal filter option and enter the expression there.
Just noticed you said you were not using FileMaker 11
Thus a calculation field could be used to match selected values as part of the relationship instead and you'll get the same result for FileMaker 10.
YourTable::cSelectedKey = Customer::Selected
cSelectedKey would be a calculation field that returns the same value as the single value in your Selected field's value list.
Retrieving data ...