Me again…

Wasn’t sure exactly where to post this since it is about both tables and forms.

This database was one of my first projects, and I need to re-jig it for use again. Now, don’t hate me but I haven’t really used Primary Keys (slap on the wrist). At the time I was in a real hurry and I simply couldn’t get my head around how else to work it.

The scenario is this… For a candidate, we select a couple of “developmental opportunities”. We then need to select a few paragraphs specific to that candidate for each “developmental opportunity”. For each opportunity, there can be at least 10 paragraphs.

Then each candidate can have a nice report specifically for them that lists among other things

Developmental Opportunity (Name)
Introduction (brief overview)
Paragraph 1
Paragraph 2
Paragraph 3

…And again for each opportunity

Structure wise, what I have at the moment is:

TblCandidate
- CandidateID (PK, Autonumber)
- FirstName
- LastName
- …etc

TblDevelopmentOpp
- DevelopmentID (number)
- DevelopmentName (text)
- DevelopmentIntro (memo)

TblDevelopmentOppParas
- ParaID (number)
- Para (memo)

TblCandidateDevelopment
- CandidateID (FK, Number)
- DevelopmentID (Number)
- ParaID

What I would like to do firstly is normalise the tables and secondly work out how to create a form for data entry. With regards to the form…

I’d like the evaluator to be able to (for each candidate) tick a box to select a developmental opportunity, and when that is chosen, for them to select up to three paragraphs that refer to that developmental opportunity. This needs to be done for at least three developmental opportunities.

Not sure how to work the checkboxes with the paragraphs! Or how to show only paragraphs that relate to a specific “opportunity” as each said “opportunity” is chosen for each candidate.

Let me know if I’m not talking sense!!! Am very tired

Thanks in advance,
Averil

I'm not sure exactly what you're doing.
Is a paragraph tied to an Opportunity, or is it tied to an Opportunity/Candidate? For example:
If tied to Opportunity:
Opportunity - Access Programmer
Paragraph1 - must be very smart and know ACCESS....
Paragraph2 - must understand non-technical people....
Paragraph3 - must be able to write good documentation....

If tied to Opportunity/Candidate:
Opportunity - Access Programmer
Candidate - John Smith
Paragraph1 - is a smart person and has great ACCESS experience
Paragraph2 - Mr. Smith understands non-technical people well, but sometimes loses his temper
Paragraph3 - John can write documentation but not as well as a professional writer

Either way, you may find it best to create a sub-form which shows the paragraphs appropriate to the Opportunity or to the Candidate; rather than try to create check boxes.

I'll check back in a few hours from now (10:36 Eastern US Daylight time); or maybe tomorrow - perhaps someone else will have had some great ideas before that!

Bob

OK. Reading through my first post again… I didn’t really make sense. To help clarify. “Developmental Opportunities” are more like areas for development. The “paragraphs” are, ummm… paragraph combinations/possibilities of each Opportunity

Paragraphs are related to the Opportunity. And Candidates have Opportunities and associated Paragraphs

Where I might have Opportunity “Selling to Existing Customers”, the possible Paragraphs for it are Paragraphs 1 through 5. Candidate “John Smith” is assigned “Selling to Existing Customers”, with Paragraphs 1, 2 and 5

Opportunity - Selling to Existing Customers

Paragraph1 - Proactively request internal…
Paragraph2 - Develop your ability to…
Paragraph3 - Though you may know…
Paragraph4 - Don't fall into the trap of
Paragraph5 - Make sure that you find…

So John Smith’s report (at the end of the day) would look like:

Selling to Existing Customers:
- Proactively request internal…
- Develop your ability to…
- Make sure that you find…

Second “Opportunity”
- Paragraph2
- Paragraph5
- Paragraph6

What I need to do is have a form where the evaluator can select multiple Opportunities for a candidate, and for each Opportunity be able to see its associated Paragraphs. From there the evaluator needs to be able to select the Paragraphs that relate to that Candidate.

Clear as mud ???

Let me know if you have any further questions.

Regards,
Averil

See if the attachment is close to what you want. It's very rough, but, it should give you an idea.

HTH
Noah

Noah,

I could kiss you!!! I'll have a play with it and see if I can get it to do what else I need.

Thank you so much.

Regards,
Averil

You are welcome!

You could include the overview as a memo field in the evaluations table, and put that in the Report Header section of the report.

Noah