Inventory DAtabase

  • Thread starter ×ירית
  • Start date
×

×ירית

Hi,

I have an Inventory DB.
SupplierTbl – SupplierID, SupplierName
CustomerTBL – CustomerID, CustomerName
PartsTbl – PartID, PartModel, PartSN, SupplierID

I should create 2 forms:
Incoming form (to my stock) that should contain: IncomingID, part model,
part serial number etc. for every part I'm recieving to my stock.
Delivery form: (to a customer) with the same details, for every part/parts
I'm sending from my stock.

I want to be able to:
1. Keep history for each part
2. Know my stock status – How many parts from the same model I have.
3. When I'm adding a new delivery record I want to be able to choose from
my stock list the parts that should be on this form (I don't want to re-type
the serial number)

Until now, all I've tried didn’t have the results I want.

Thx for your help

Irit
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top