For some reasons, such as More than one Pro-forma Invoice are packed in one shipment. The Invoice need to group more than one Orders record into report to get the overall some total!

but currently I take the only one Inv_no to print report...
To do print more than one Inv_no, I need to add a table to do.
e.g. PrtINV which has only one Field on Inv_no and make Join on Previous Report View....

But there will be a big problem as multi-user want to print/preview different Invoice at the same time, but the PrtINV can't carry totally different content at the same time!!

For User A, he wants PrtINV table has 5 entries:
Inv3004, Inv3008, Inv3011, Inv3012, Inv3014

For User B, she wants PrtINV table has 2 entries:
Inv3013, Inv3015

Although most of the time, my application allow mutli-access but now become unique exclusive access... What can I do?!

---

My previous View version is simple designed in View Designer:
Select ...
where .... and Orders.Order_id = ?MemVarOrder_id

It allow multi-access and more than one people can print/preview at the same time!

Since there are many report are using that View, change it to use Macros Cursor with using Inlist() will hard to handle current operation and maintain in furture... >.<'

macView = "select... Where .. Inlist(Orders.order_id, " + Listbox.item(1) + "," + ... + " into cursor tmp"

&macView

---

Are there any method to handle this problem with multi-access!?