Mark Items in Report When Printed

[Therber]

Hello. I'm working on an ordering system for a business. I have a report which shows me a list of products which need to be ordered from a single vendor. I need to develope a system for signifing the items in the report as "on order" only when the report is printed.
How does this sound:
To make the items in the report unique, I could create a unique concatenated field. I imagine I need to copy the report information to another file temporarly when the report is first created. If the user decides to print the report, a script then takes the temporary file info and matches it to the original items using the unique concatenated field and markes the items as "on order" (a checkbox maybe).
Anyone know of a solution? Thanks.

 

[lebisol]

ur on the right track.....no need to make it more complex...just make a simple field and update it when the "print script" is executed.
eg. dialog box:

======print===========

Did your report print?
 [ yes ] [ no ]
========================

and use something like
IF print="YES" then set field "printed" to currentdate
and perhaps conditinally show it:
IF field "printed" not empty then wirte "already printed" or show a date on whihc it was printed....
just a thought!
All the best!


> need more info?
:: don't click HERE ::