I have No idea what to call it to search for it...? 1

[Elvis72]

I have the following for a language selection so a user may speak multiple languages.

SELECT [Resume Language Table].[Language ID], [Resume Language Table].[Worker ID], LanguageTable.Language
FROM LanguageTable INNER JOIN [Resume Language Table] ON LanguageTable.[Language ID] = [Resume Language Table].[Language ID];

Which works great, with it as a subform its awesome.

I am looking to take it a step further but not sure how.

I have one project that might need:

2 Lead Engineers
2 Mechanical Engineers
1 Document Control

So, I'm thinking I can use the same philosophy to track the above?

So I have:

TblStaffRequirements -

Title ID
Title

TblStaffRequirementsList -

Job/ProposalNo
TitleID
StaffRedID

TblConstructionServices

Job/ProposalNo
(and other fields)

So, is it feasible to add a dropdown number field or a text field for data entry?

So Basically you would be on the Construction Services Form and see this subform:

Staffing Requirements:

Project Manager 2
Project Engineer 2
QC Manager 1

Any help or questions are GREATLY appreciated!~

 

[MajP]

What is your question?

If I understand your structure:

TblStaffRequirementsList -
Job/ProposalNo
TitleID
StaffRedID


This lists the staffing requirements for a job?
Job/proposalNo is a foreign key linking to a proposal. Title ID is the link to a job title. What is the StaffRedID?
You would need to add a quantity required field "intTitleQuan" which holds the value for how many TitleIDs are sourced for a given proposal.

 

[Elvis72]

OK...let me see if I can clarify?

I have the mainform that has the Job/ProposalNo information
then I need a subform that shows a list of positions required for that job and the number needed and the number staffed.

So, I have a language table that shows the languages a person knows and I can start typing in the box and that language will populate.

What I need to know is if I can add numeric fields for the staffing requirements to the TblStaffRequirements and have it work?

 

[MajP]

If all my assumptions about your table structure are correct, then yes you can.

 

[Elvis72]

Wooohoo...so figured it out!~

Thanks!~