E
ethereal.hell
Hi,
I am trying to create a form in Access that allows for the entry of the
particular user's information and the items they would like to check
out. I want the form to be able to check out multiple items under one.
The DB is set up that there is a table with the Inventory, which holds
each item code, qty in stock and other information, another table with
current checked out "sheets", and another one containing the items
checked out, which are referenced to the "sheets" by a number so that
sheets in general can be tracked seperately.
I created a form that has a drop down for the TYPE, ITEM, and text
boxes for QTY and Item#(ie computer 1). The form is included as a
subform in continuous records mode in a larger form that allows for the
entry of user id information and a date. The form is successfully set
up to actually enter the data into each table correctly. My problem
that I face now is that the drop down for TYPE changes the drop down
for each "type" drop down.
Is there a way without using too much or any VBScript to allow for this
kind of set up to avoid this problem? I will only share the database
with those who are seriously considering to help, being that the
information in the database is not exactly for public viewing.
Thanks,
Trent C
IT Student Worker at DeVry University Help Desk
I am trying to create a form in Access that allows for the entry of the
particular user's information and the items they would like to check
out. I want the form to be able to check out multiple items under one.
The DB is set up that there is a table with the Inventory, which holds
each item code, qty in stock and other information, another table with
current checked out "sheets", and another one containing the items
checked out, which are referenced to the "sheets" by a number so that
sheets in general can be tracked seperately.
I created a form that has a drop down for the TYPE, ITEM, and text
boxes for QTY and Item#(ie computer 1). The form is included as a
subform in continuous records mode in a larger form that allows for the
entry of user id information and a date. The form is successfully set
up to actually enter the data into each table correctly. My problem
that I face now is that the drop down for TYPE changes the drop down
for each "type" drop down.
Is there a way without using too much or any VBScript to allow for this
kind of set up to avoid this problem? I will only share the database
with those who are seriously considering to help, being that the
information in the database is not exactly for public viewing.
Thanks,
Trent C
IT Student Worker at DeVry University Help Desk