Inventory Tracking

[RammerJammer1674]

Hi everyone,

I'm not real sure which thread to ask this question in, so I'll just put it here.

What's the easiest way to track inventory?

I have Tables set up of Products, Inventory, Orders, Job Numbers.

Job Numbers will have Products particular to that Job.

You can Order Products for a Job Number OR for Inventory.

What's the easiest way to do this? Does anyone have a sample of this? Thank you!

 

[spikepl]

Perheps you'll fine a suitable data model here: http://www.databaseanswers.org/data_models/
For inventory, see http://allenbrowne.com/appinventory.html

 

[RammerJammer1674]

That's perfect. Thank you so much!