Hi,

I am new to filemaker Pro, working hard on it though. I have to search for records in a date range. I know how to do find the records, if I do a find from the same table. In my case, I have 2 tables -

Clients - fields are :Client Id and Course ID

Courses- fileds are Course #, Title and Start date.

I could go to table Courses and search for records with Start date in a given range. (The info for this if anyone is interested can be found at - http://www.filemaker.com/ti/109090.html). But I want to search for records in Courses in a range of dates from the table Clients. When I run a script to display the found records in a layout in the Clients table, I get the message "Operation Could not be completed as this layout cannot display the result". I have included all the fields from the Course table. Can somebody help me out here??

Thank you.

OK, a layout in FM7 is associated to 1 table occurance (in the relationships graph) this is the layout's "Context", this means that FileMaker will only display records from a specific table in any 1 layout, I could do with seeing the script to see where that error message might have come from. But in terms of thinking about the problem properly, try thinking of it as you are performing a find on the client records, i.e. the range of clients who started their course in a specific date range.

But I need more information to diagnose any further. What are the contents of the Perform Find script step? As these should just work provided there is a connection in the Relationship Graph from the context of the current layout to the Find Request's table occurance.

I assume this is just followed by a Go To Layout, but this seems to work on any test I've done

Hi Matt,

I am sorry I couldn't reply to your answer earlier. I am still stuck with the problem. The steps I used are :

I created a self join relationship for the Table Courses as this has the course date, the criteria for the range. The occurence created was called Courses 2. This is done in the relationship graph of Table Clients.

The script I ran in Clients Table is

Get related record from- Courses 2.

Show Record Using "current Layout".

Show only related records.

I get the same error as mentioned earlier. I run this script from Clients table and hence the Show Record using current Layout means the layout from where I run the script.

Both Courses and Clients have the field Course ID, by which they are related. I didnt really get you when you said " As these should just work provided there is a connection in the Relationship Graph from the context of the current layout to the Find Request's table occurance." could you please explain? I think I am missing out on making some relationship!

Thanks a lot.