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)
…And again for each opportunity
Structure wise, what I have at the moment is:
- CandidateID (PK, Autonumber)
- DevelopmentID (number)
- DevelopmentName (text)
- DevelopmentIntro (memo)
- ParaID (number)
- Para (memo)
- CandidateID (FK, Number)
- DevelopmentID (Number)
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,