Newbie: Help with complex scenario

[tannerSF]

I am developing a custom application tracking system for my travel nursing and healthcare staffing company. The system will have modules for job orders & website, contracts management, human resources, time & billing, etc. There are custom layouts for my in-house recruiters and admin staff. I am also using CWP for the online application that individual candidates will use to register and manage their own account.

Everything has gone smoothly until now and I was not able to find the solution in the FMP Bible mainly because I did not know what to look for specifically.

Here is the scenario--when entering a new Candidate, they will select their professional discipline (ie. RN, LVN, MD, DDS). When a discipline is selected for that candidate, I want a new menu to present Specialties that are specific to their discipline. Then when a specialty is selected, I want a new windows to present a clinical skills checklist for that specialty. Each candidate can have multiple specialties; therefore there could be multiple skills checklist. Below is the way I have a few of my tables setup. :qwery:

TABLE 1: Candidate

• idCandidate
• nameFirst
• nameLast
• Discipline
• several other fields...

TBL2: RNSpecialty

• idCandidate
• idSpecialty
• Specialty
• YearsExperience
• LastWorked
• various other details...

*Specialty is a "Managed Value List"

TBL3: ERSkillsCheck

• idCandidate
• idSpecialty
• idERSkill
• Skill1
• Skill2
• Skill3
• Skill4
• Skill5
• Skill6
• Skill7
• Skill8

TBL3: ICUSkillsCheck

• idCandidate
• idSpecialty
• idICUSkill
• Skill1
• Skill2
• Skill3
• Skill4
• Skill5
• Skill6
• Skill7
• Skill8

TBL3: LDSkillsCheck

• idCandidate
• idSpecialty
• idLDSkill
• Skill1
• Skill2
• Skill3
• Skill4
• Skill5
• Skill6
• Skill7
• Skill8

So do I need to setup some sort of script, function, or calculation so those specific actions would take place? If someone can point me in the right direction or offer assistance, it would be greatly appreciated.

-tanner

SIP: [email protected]

[nox]

I'm just beginning with FM myself also, but I think the solution to your problem is a simple use of conditional value lists.

check this topic: http://www.fmforums.com/forum/showtopic.php?tid/181645/

or search for "conditional value list" in forum.