Help - combo box values from competitors age

[Smithyonline]

I'm trying to create mt first database and quickly finding I'm out of my depth so thanks in advance

i have a table of competitors and a table of sections (for a competition) the sections have min and max age and the competitors have an age
I'm trying to build a form to input entry's i have two combo boxes to select competitors so want a third combo box to only display relevant sections that the competitors can enter

i have been playing with creations a query to only show the available sections but cant get this right



please help

Adam

[orange]

I'm trying to create mt first database and quickly finding I'm out of my depth

I suggest you work your way through these links to get a good appreciation of relational database first.

Good luck.

[Smithyonline]

Sorry out of my depth was prob the wrong wording i have been working though an access course with Amicron Computing but following a worked example and applying it are totally different

i have been trying to create a combo box that pulls its value from a querie but i want to limit the values depending on the ages of 2 selected competitors so that an older competitor is not entered into a younger section but the younger competitor can be enter into a older section

hope that makes sense

many thanks for any advice

[Micron]

I think you are asking how to create cascading combo boxes. Here's one link http://www.fmsinc.com/microsoftacces...cascading.html
If you Google the term, you can find about 30K more pages on the subject.

[Smithyonline]

thank you ill read up on cascading combos