Setting a status field on exporting data

Are these records related in any way? ie all children of a parent record?

Here's what I have in mind, hopefully this makes sense for your scenario:

• Parent table, let's call it Exported
  
  • This table has a field called Paid, probably a checkbox
• Child table has all your sales, lets call that Sales
  • This table pulls the Paid checkbox from the parent

Now, when it comes time to export a set of records, relate them all to one parent. Export the data. Then mark the parent as Paid, which will cascade to the children. If that works, I think a formula url could do it all in one shot.

------------------------------
Matt Hardy
------------------------------