V
vandy
Hi All,
I have a scenario were I am managing an inventory database.Each item stored
is based on a project. Once the project is over and if there are inventory
spares left out , the items should be moved to a table called Rawmaterial to
be used for future project.
I want the user to be able to select the records he wants to move to the
rawmaterial which will delete the entry in the exisiting table and move both
sturucture and data to the rawmaterial table.
Table Structure
tblprojects~~Table Name
pno – project nmber – primary key
pname- project name
tblitems~~ Table Name
Itemno - Item no – primary key
Prno - project number – primary key ( combination of both keys makes the
data unique)
Uom – Unit of measure
Cat_id – Cat id
Stock_no – Item stock no
Nuclear – Nuclear material or not
Selected – select flag
tbltransactions~~Table Name
transactionID – Autonumber
Itemno – Foreign key connecting tblitems
ItemID
DOR – Date of Receipt of item
UnitsReceived - Qty Received
DOI – Date of Issue of item
UnitsUsed – Qty Issued
Location – Location stored
IssuedTo – Issued to person or job
I want to use the select flag in the tblitems table to move the items. Is
this possible. I do need help in vb as well as access sql query.
thanks in advance.
I have a scenario were I am managing an inventory database.Each item stored
is based on a project. Once the project is over and if there are inventory
spares left out , the items should be moved to a table called Rawmaterial to
be used for future project.
I want the user to be able to select the records he wants to move to the
rawmaterial which will delete the entry in the exisiting table and move both
sturucture and data to the rawmaterial table.
Table Structure
tblprojects~~Table Name
pno – project nmber – primary key
pname- project name
tblitems~~ Table Name
Itemno - Item no – primary key
Prno - project number – primary key ( combination of both keys makes the
data unique)
Uom – Unit of measure
Cat_id – Cat id
Stock_no – Item stock no
Nuclear – Nuclear material or not
Selected – select flag
tbltransactions~~Table Name
transactionID – Autonumber
Itemno – Foreign key connecting tblitems
ItemID
DOR – Date of Receipt of item
UnitsReceived - Qty Received
DOI – Date of Issue of item
UnitsUsed – Qty Issued
Location – Location stored
IssuedTo – Issued to person or job
I want to use the select flag in the tblitems table to move the items. Is
this possible. I do need help in vb as well as access sql query.
thanks in advance.