troubleshooting Question

Stock/Inventory System Design Ideas

Avatar of shuboarder
shuboarderFlag for United Kingdom of Great Britain and Northern Ireland asked on
Lotus IBM
33 Comments12 Solutions7707 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 12 Answers and 33 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 12 Answers and 33 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros