E
Elvis72
OK, I have an Experience subform and a Staff Requirements subform that works
wonderfully with my forms.
In the Experience subform I just have a title and the ID related to that
title.
For Staff Requirements I kicked it up a notch and added # Needed and #
Staffed to the StaffRequirementsID table, and it works great.
What I need to do is kick the next one up another few notches, I have a
ConstructionServices Table and a Resume Table.
What I need to do is bring information from the ConstructionServices Table:
Location
Title
Client
Status
Together with:
ProjectInfoforResumes Table that has:
WorkerID (Resume Table)
Job/ProposalNo (ConstructionServices Table)
ProjectInfoID
Hourly Rate
Position
Mobilization Date
Demobilization Date
Which will be placed in a subform on FrmResumes that shows each project that
person has worked on and in what capacity.
BUT also has the ability to add records by using a combobox that combines:
Client
Title
Job/ProposalNo
and have the balance of the information services populate after selection.
I have another form that has a subform that populates when you type in
WorkerID but it is easier for users if there is a dropdown combobox they can
search through.
Any help is greatly appreaciated!~
thanks!~
wonderfully with my forms.
In the Experience subform I just have a title and the ID related to that
title.
For Staff Requirements I kicked it up a notch and added # Needed and #
Staffed to the StaffRequirementsID table, and it works great.
What I need to do is kick the next one up another few notches, I have a
ConstructionServices Table and a Resume Table.
What I need to do is bring information from the ConstructionServices Table:
Location
Title
Client
Status
Together with:
ProjectInfoforResumes Table that has:
WorkerID (Resume Table)
Job/ProposalNo (ConstructionServices Table)
ProjectInfoID
Hourly Rate
Position
Mobilization Date
Demobilization Date
Which will be placed in a subform on FrmResumes that shows each project that
person has worked on and in what capacity.
BUT also has the ability to add records by using a combobox that combines:
Client
Title
Job/ProposalNo
and have the balance of the information services populate after selection.
I have another form that has a subform that populates when you type in
WorkerID but it is easier for users if there is a dropdown combobox they can
search through.
Any help is greatly appreaciated!~
thanks!~