report field

[Ty Murray]

Hello to anybody who can help....I'm trying to find a way
to produce a set of purchase orders, each set of
purchases is seperated by a page break and grouped
according to the name of the business,I'm trying to find
a way to create a unique purchase order number for each
vendor.

Thank you

 

[Marshall Barton]

Hello to anybody who can help....I'm trying to find a way
to produce a set of purchase orders, each set of
purchases is seperated by a page break and grouped
according to the name of the business,I'm trying to find
a way to create a unique purchase order number for each
vendor.

How about creating a table with a field for the company ID
and another field for the last used PO number. Then,
whenever you need a new PO for a company you can look it up
in the table, increment it, save it back to the table and
use the new number as needed.

Since you posted this question in the reports newsgroup, I
want to caution you that creating numbers like this in a
report is not a good idea. Reports may be printed or
previewed many times, while the PO numbe should only be
assigned once.