I have an InventoryControl Database I am setting up. It has two tables:
Table One: InventoryDescription:
CharterNo (PrimaryKey)
OldCharterNo
Description
VendorNo
Vendor
Manufacturer
StartInventory
AmtRecd
AmtIssued
EndInventory
ItemCost
ReorderAmt
Table Two: InventoryTransactions
TransactionNo (PrimaryKey/AutoNo)
CharterNo
Date
TechNo
ApprovalNo
Contractor
ToNode
AmtTruckStock
In the first form what I need is when I type in CharterNo it brings up all the other data on the table: OldCharterNo, Description, etc., so my people can be sure that they have the right item. Then I open the second (linked) form (toggle) and the same CharterNo comes up with the other fields in Table Two; I then will enter how many rec'd, etc. I want to be able to keep running inventory (thus I need it to calculate) and also to be able to go back and pull up what changes were made on what date. So, the second table is blank but will be populated with the info I enter and will be my records table. I do not want to change/enter any data in Table One; as a matter of fact, I want to protect it from any changes.
So, to reinterate: Open form, type in CharterNo which brings up description; toggle open second form, enter inventory data (and the form will automatically add/subtract as appropriate), save on Transaction table,
move onto next item. I do want auto date (but I figure that out, except I get date/time and I only want date).
I hope this is clear
.
I know it's a simple project compared to what you all do, but even tho I am getting better at Acess, I am still very new at it!
Thanks!
Jackie
Table One: InventoryDescription:
CharterNo (PrimaryKey)
OldCharterNo
Description
VendorNo
Vendor
Manufacturer
StartInventory
AmtRecd
AmtIssued
EndInventory
ItemCost
ReorderAmt
Table Two: InventoryTransactions
TransactionNo (PrimaryKey/AutoNo)
CharterNo
Date
TechNo
ApprovalNo
Contractor
ToNode
AmtTruckStock
In the first form what I need is when I type in CharterNo it brings up all the other data on the table: OldCharterNo, Description, etc., so my people can be sure that they have the right item. Then I open the second (linked) form (toggle) and the same CharterNo comes up with the other fields in Table Two; I then will enter how many rec'd, etc. I want to be able to keep running inventory (thus I need it to calculate) and also to be able to go back and pull up what changes were made on what date. So, the second table is blank but will be populated with the info I enter and will be my records table. I do not want to change/enter any data in Table One; as a matter of fact, I want to protect it from any changes.
So, to reinterate: Open form, type in CharterNo which brings up description; toggle open second form, enter inventory data (and the form will automatically add/subtract as appropriate), save on Transaction table,
move onto next item. I do want auto date (but I figure that out, except I get date/time and I only want date).
I hope this is clear
.I know it's a simple project compared to what you all do, but even tho I am getting better at Acess, I am still very new at it!
Thanks!
Jackie
