J
Jacinda
Hello to all... I have a little question...
I have a form for creating purchase orders. Each purchase order has it's own
uniquie PO number, then there can be several items ordered under that order
number. I need to create a sequence starting with 1 up to what ever number of
items is created on the po.
For example PO 99999 item 1 of 6; Item 2 of 6.
The PO information goes on one table, and the items go onto a detail table.
I don't want to use auto number because it will not restart from 1 for the
next PO.
What is the best way to do this, as I need the "1 of" to print on a report.
I have a form for creating purchase orders. Each purchase order has it's own
uniquie PO number, then there can be several items ordered under that order
number. I need to create a sequence starting with 1 up to what ever number of
items is created on the po.
For example PO 99999 item 1 of 6; Item 2 of 6.
The PO information goes on one table, and the items go onto a detail table.
I don't want to use auto number because it will not restart from 1 for the
next PO.
What is the best way to do this, as I need the "1 of" to print on a report.