Jump to content
Sign in to follow this  
donal123

values and relationships

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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...

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.