Is there a way to write a script to find the records due on the next due date?

I have a database of all due dates, and the invoice code that is on each record due that day (001 is due 01 Nov 01, 002 is due 04 Nov 01, etc)

i want to create a script that would find the transactions that are due only on the next due date. If today is Nov 10th, and the next due date in the due dates database is Nov 15, i want to be able to run the script and have it find only the records due on the 15th.

I am trying to automate my system as much as possible so the less experienced users will have an easier time using the software.

Is this possible? if so, suggestions?

thanks,

Sure. In the due dates file, write a script that sorts the due dates in ascending order, loops through the due dates and finds the first one greater than (or greater than and equal to) today. Capture this due data and move to your other file and use either a find or a "go to related record" to isolate the records for this date.

-bd