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!?
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.