I need to design a stock/inventory system in Lotus Notes.
This is to form part of an already existing database.
I imagine I will use a form to allow users to add/adjust stock levels, then have a view to display the stock.
In an already developed part of the database I will have an area that will allow users to say which stock they have used.
My question is, how can I adjust the stock level from another document?
i.e. if user A adds stock of 5 bolts through form A
user B then says that he has used 2 bolts through form B
how can I get stock to show at 3?
I imagine I will need to use a lookup from form B to view A to get available stock (no problem)
It's how I adjust the document that is looked up.
Does this make sense?
Any help much appreciated.