Complex find.

[newtm]

I have an "invoice" form with a Purchase Order field.

There is a portal that lists "line item" details, including a status field in which backorders are designated.

How do I create a new invoice for a specific purchase order number

that also shows only the open backordered items in the portal.

This must be a common problem for invoicing programs, but I can't think of a way to do it.

Thanks for any help I can get.