I want to set up a relationship which displays records from table A in a portal in table B. The records which should appear are those between start date B and FInish date B. There's a simple example in Filemaker Help for just this setup, but it's not working for me for some reason.

I set up a dummy match field in each table to test that the portal is correctly set up. This works fine, returning all the records in table A, but as soon as I add comparative operators to any other fields in the relationship (with or without the original dummy match fields), all the records disappear. I've checked that I'm using the right fields, and double-checked the date ranges to confirm that there are qualifying records.

Can anyone suggest what I may have overlooked? I have similar relationships between other tables in this database which are working fine.

Baffled of Barcelona.

This is a double non-equijoin relationship. Look at your Relationships Graph to see how tables A and B are related. In the connections dialog box you should have an AND'd relationship between date >= start date and date <= finish date.

In addition, if you were to list records falling within a given date Range while Table B has only one date field, your relationship should read

TableA ----------------TableB

IDA--- ---- = ------IDa

And gDateStart-- <= ----- Date

And gDateEnd-- >= ----- Date

Thanks guys-

I located the problem in the end. My 'date' field in table A is a calculation field, but I had the calculation result set at 'number' instead of 'date'. Even though the result was returned in date format it couldn't be read by the relationship.

Jon