Subform Relational Issue

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!~
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top