Hi Claude,
>Can I some how still use private data sessions and still have changes in inventory table be seen by Form A so it knows that there are really enought items in stock to complete the order?
The short answer is yes, by refreshing Form A's inventory list in Form A's Activate() event. How you refresh Form A's 'inventory list' depends on how you access the inventory. For example, if you are using a view you need to requery the view. If inventory is displayed in a listbox or combobox you need to requery that control.
HTH
George Simon, MCP