This should be easy but....

I am Brand new at Access but I can't seem to make a seemingly simple task
work, A Simple sign out system, I have 3 Data bases, STUDLIST, EQUIPINV, and
SignedOutEquipment, I have a form with a textbox that asks for a student ID,
when an ID is enterd I need it to get the student info from STUDLIST, and
load it into form 2, then prompt for a barcode #, get this info from EQUIPINV
fill the rest of the form and add this record to SignedOutEquipment. This
second part needs to loop as a single student may sign out multiple peices of
equipment at a time. but return to the start page if nothing is entered in
the prompt and return is pressed.
I have been able to get the form to fill the student info, or the equipment
info but not both and it is driving me nuts. Help.

I have 3 Data bases, STUDLIST, EQUIPINV, and SignedOutEquipment,
These are tables, not 'databases.'
Have a StudentID (Autonumber) as primary key for the STUDLIST table.
Have EquipID (Autonumber) as primary key for the EQUIPINV table.
Have SignOutID (Autonumber) as primary key for the SignedOutEquipment table.

In the SignedOutEquipment table also have StudentID (Number - long integer -
foreign key) and EquipID (Number - long integer - foreign key).

Create a one-to-many relationship between the primary key and the foreign
key fields. Select Referential Integerity and Cascade Update options.

The main form have student information and subform have the equipment
checked out. Set the Master/Child links using the StudentID primary key of
STUDLIST in main form to the StudentID foreign key of the SignedOutEquipment
in the subform. The subform have combo to select equipment.

The key fields do not need to be shown in the forms.

--
Build a little, test a little.


"wftech" wrote:

I am Brand new at Access but I can't seem to make a seemingly simple task
work, A Simple sign out system, I have 3 Data bases, STUDLIST, EQUIPINV, and
SignedOutEquipment, I have a form with a textbox that asks for a student ID,
when an ID is enterd I need it to get the student info from STUDLIST, and
load it into form 2, then prompt for a barcode #, get this info from EQUIPINV
fill the rest of the form and add this record to SignedOutEquipment. This
second part needs to loop as a single student may sign out multiple peices of
equipment at a time. but return to the start page if nothing is entered in
the prompt and return is pressed.
I have been able to get the form to fill the student info, or the equipment
info but not both and it is driving me nuts. Help.

"KARL DEWEY" wrote:

I have 3 Data bases, STUDLIST, EQUIPINV, and SignedOutEquipment,
These are tables, not 'databases.'
Have a StudentID (Autonumber) as primary key for the STUDLIST table.
Have EquipID (Autonumber) as primary key for the EQUIPINV table.
Have SignOutID (Autonumber) as primary key for the SignedOutEquipment table.

In the SignedOutEquipment table also have StudentID (Number - long integer -
foreign key) and EquipID (Number - long integer - foreign key).

Create a one-to-many relationship between the primary key and the foreign
key fields. Select Referential Integerity and Cascade Update options.

The main form have student information and subform have the equipment
checked out. Set the Master/Child links using the StudentID primary key of
STUDLIST in main form to the StudentID foreign key of the SignedOutEquipment
in the subform. The subform have combo to select equipment.

The key fields do not need to be shown in the forms.

--
Build a little, test a little.


I don't believe that will work for me let me try to explain,
The primary key in STUDLIST is IDNUM, The Primary Key in EQUIPINV is
BARCODE, I sign out over 1600 seprate peices of equipment to over 250
students over a semester, the drop box approach will not do it.
I have student workers that will be signing the equipment in and back in
again and I need a simple interface that will do all the work
I need the form to prompt for the IDNUM then get that record then prompt for
BARCODE and get that record, then add that combination record with the date
out into SignedOutEquipment. that is used to keep track of our stuff and
print out overdue lists indexed on Date out so faculty can enforce policy
I appreciate any help

Ok, use IDNUM and BARCODE instead of field names I put.

Have the STUDLIST prebuilt so that it is correct. The combo box allows
selection from dropdown or type entry. Additionaly you can use the
AutoExpand feature that automatically scroll as you type in the name.

The BARCODE combo also will let you type but control entry so there will not
be any typing errors in the signout once the equipment table is populated.

In the signout field of the form set the default to Date() or Now() based
upon whether you want current day or day with time.

Use a separate form with additional datetime field to record returns.

--
Build a little, test a little.


"wftech" wrote:



"KARL DEWEY" wrote:

I have 3 Data bases, STUDLIST, EQUIPINV, and SignedOutEquipment,
These are tables, not 'databases.'
Have a StudentID (Autonumber) as primary key for the STUDLIST table.
Have EquipID (Autonumber) as primary key for the EQUIPINV table.
Have SignOutID (Autonumber) as primary key for the SignedOutEquipment table.

In the SignedOutEquipment table also have StudentID (Number - long integer -
foreign key) and EquipID (Number - long integer - foreign key).

Create a one-to-many relationship between the primary key and the foreign
key fields. Select Referential Integerity and Cascade Update options.

The main form have student information and subform have the equipment
checked out. Set the Master/Child links using the StudentID primary key of
STUDLIST in main form to the StudentID foreign key of the SignedOutEquipment
in the subform. The subform have combo to select equipment.

The key fields do not need to be shown in the forms.

--
Build a little, test a little.


I don't believe that will work for me let me try to explain,
The primary key in STUDLIST is IDNUM, The Primary Key in EQUIPINV is
BARCODE, I sign out over 1600 seprate peices of equipment to over 250
students over a semester, the drop box approach will not do it.
I have student workers that will be signing the equipment in and back in
again and I need a simple interface that will do all the work
I need the form to prompt for the IDNUM then get that record then prompt for
BARCODE and get that record, then add that combination record with the date
out into SignedOutEquipment. that is used to keep track of our stuff and
print out overdue lists indexed on Date out so faculty can enforce policy
I appreciate any help