Database Tracking Stock with Serial No's

[stecon29]

Hi

My first time on the site

I am currently trying to design an access DB to track movement of stock we have that has unique serial no's.

We order the stock from one Supplier and then distribute it to our network partners, I am trying to work out the best way to log the intake of stock and then distributing it to our partners and then need to track when a partner uses the products (they send weekly reports of stock used) so I can track stock levels with them, the stock is one time use only

I have built basic DB's before but this is taking me to the next level so want to make sure I do it the correct way

Any help would be appreciated

Thanks

[twinnyfo]

stecon,

Welcome to Bytes!

Sounds like you are asking more for a project than for an answer to a specific trouble area. Are there some specifics you need hepp on?

Your request seems very broad.

We are glad to hepp if we have more specific issues.