help is appreciated. thanks in advance

I am trying to create what a think should be value lists with relationships

what i am trying to achieve is having a drop down list and then a corresponding drop down list for each topic. for instance if someone selects the body part "chest" from the first value list then a list of exercises would be displayed relating to chest in the second value list. the first list would have a drop down of say each major body part chest, back, arm, leg and the second exercise type would list those related exercises.

thanks

build the second on a relation based on the first field

first valuelist= from field, database2, all values from majorbody part

2nd valuelist, based on relation majorbodypart<->database2::majorbodypart, all corresponding values from database2::bodypartdetail

how do i choose just the first topic say "chest" to relate to just the list of chest exercises in the second drop down menu

I have this exact program in my gym for my trainers.

What I do:

1 database with MajorPart and Movement fields (and descriptions, pics etc)

I have a GlobalMajorPart field with a pop up menu and the values are from the MajorPart Field. The a self relationship from Global MajorPart to MajorPart.

In a portal I list the Movements.

This system workd great and I can pick from 100's of exercise with just a few clicks.

Charles

Hi,

Make a search for conditional value lists here on the forum. Plenty of other examples.

Note that Charles solution uses a global, which may not be your case...