Viewing records from distant table

[Ballycroy]

I know that this should be easy but I just cannot get my head around it.

The file attached is for viewing records (for advertisements) which are imported into Filemaker from an external data source.

I have set up a ViewerTable to allow the user to see the associated records

which are related by:

ViewerTable:SalesNumber — OrderTable:SalesNumber

OrderTable:OrderNumber - OrderInsertionTable:OrderNumber

The relationship between OrderTable and OrderInsetionTable is One To Many

My question is how do I view records from the OrderInsertionTable from the point of view of the ViewerTable using the criteria:

SalesNumber = SalesNumber

StartDate ≥ RunDate

StartDate ≤ Rundate

Tables:

ViewerTable —

Fields:

SalesNumber

StartDate

EndDate

OrderTable —

Fields:

SalesNumber

StartDate

OrderInsertionTable

Fields:

OrderNumber

RunDate

VTtest.fp7.zip

Edited September 2, 2008 by Guest