L
Linda RQ
Good Evening Everyone,
Access 2003 but will be opened on some computers in Access 2000. I am not
yet real comfortable with forms or the form verbiage so I will probably need
some guidance as to what information is needed to help me with this.
I have a form (**with some blank fields)inserted on my main form as a
subform but I would like to have a second subform for the user to enter
records on which the user will only enter the therapy that has equipment. I
want to label one subform Pt. Therapy with no Equipment, and the other one
will be Pt. Therapy with Equipment. Both forms records will populate
sfrmqry which updates the tblPatientTherapy.
Can this be done and if so, how?
Here are my tables.
tblPatientTherapy
PtThpyID
PtID_fk
ThpyTypeID_fk
PhysID_fk
EquipID_fk----**This is blank for some records which I know is not the best
design but for the level I am at, it works best for me except for now. <g>
tblPatients
PtID
PtLName
PtFName
PtMI
tblEquipmentType
EquipID
TagNum
Description
Model
Special Location
Active
tblTherapyType
TherapyTypeID
TherapyDesc
TherapyMultFactor
Thanks,
Linda
Access 2003 but will be opened on some computers in Access 2000. I am not
yet real comfortable with forms or the form verbiage so I will probably need
some guidance as to what information is needed to help me with this.
I have a form (**with some blank fields)inserted on my main form as a
subform but I would like to have a second subform for the user to enter
records on which the user will only enter the therapy that has equipment. I
want to label one subform Pt. Therapy with no Equipment, and the other one
will be Pt. Therapy with Equipment. Both forms records will populate
sfrmqry which updates the tblPatientTherapy.
Can this be done and if so, how?
Here are my tables.
tblPatientTherapy
PtThpyID
PtID_fk
ThpyTypeID_fk
PhysID_fk
EquipID_fk----**This is blank for some records which I know is not the best
design but for the level I am at, it works best for me except for now. <g>
tblPatients
PtID
PtLName
PtFName
PtMI
tblEquipmentType
EquipID
TagNum
Description
Model
Special Location
Active
tblTherapyType
TherapyTypeID
TherapyDesc
TherapyMultFactor
Thanks,
Linda