Hi:

In the example attached on the Ad Order Table the Start Date is 13/09/2008 and the Expire Date is 18/10/2008.

Sales Number only resides on the Ad Order Table.

My question is: How I display Ad Inserts in a portal on the Viewer (Join) Table for a specific date range, i.e

27/9/08 to 11/10/08.

The data is imported from an external file.

VAXtrac.fp7_2.zip

Try this

VAXtrac_MOD.zip

Here is a solution I came up with:

Used a list function to list all the Ad Numbers for the Sales Number and then used that in a multi-key relationship to the Ad Insertion Table.

If anyone has a better solution, please let me know.

VAXtrac2.fp7.zip

Hi:

Thanks for the file, but when i imported 20,000 records it slowed down drastically when filtering

and puts up a "Find in Progress - Processing Query" message.

Edited October 28, 200817 yr by Guest