New challange, not sure where to start

[chef_tim]

Good day all. A bit of back ground, I've built a data base (with much help from the folks here) to track the training of my people. Someone way higher then me has decided to completely revamp our field training. There are now two "tiers" based on rank and training level. My first thought is to make two seperate tables for the information in each tier. What I would like to do is make the training specific to each tier show up on the form that I use to track this training based upon the persons rank. Ie an Airman would only show the tier one tasks and a Master Sergeant would show the tier two tasks. I'm thinking this could be done with a quiery but have no idea how to go about it. Any input or suggestions are welcome. Thanks in advance, Tim

 

[Banana]

Sounds like you would want a table containing Rank with their corresponding tier, so when you select a Rank, you can lookup the tier and update the listbox according to it.

Is that what you want?

 

[chef_tim]

I think if it was one task then that would work, unfortunatly there are about six tasks associated with each tier. Thanks for the idea, tim

 

[Banana]

I think I have a idea of what you need, but need some information.

Am I right in assuming that

1) Rank only has one tier, but one tier can have several ranks
2) Tiers has several tasks, but tasks are specific to only one tier
3) A Rank can have several tasks, and tasks can be applied to different ranks?

Let me know if that this is what you intend.

 

[chef_tim]

I think you're getting what I'm saying. I'll try to elaborate

tier one- Tier two-
AB through SSgt (Ranks) TSgt though CMSgt and officers (Ranks)
A set of specific tasks A different set of tasks

So what I would like based upon the persons rank is that set of tasks associated with their tier to appear on the form I use to input training dates. Again, I thank you, Tim

 

[Banana]

Sounds like you do need only two tables. That is if the set of tasks belong only to one tier. Since you want to display tasks based on rank, you can simply use the Rank table I proposed earlier, create a query to filter out the tier field so you'd see only tasks for a given tier.

To reliterate,

tblRanks

RankID
Rank

tblTask
TaskID
Task
Tier

You would need three tables if there were going to be tasks that would belong in both tiers, though.

 

[chef_tim]

Just a quick update, I have a table built for each tier and now I'm trying to figure out how to quiery each of them. Thanks, Tim