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
|
