I think Option 2 from the original thread you referenced is a better approach. Then you can load these values in a tables and establish a relationship that filters the list of values to those appropriate for each selected value.
You might also consider not using repeating fields for this type of data entry. A table of related records often is much easier to work with when you need to generate reports of this same information.
Thanks so much for your reply. Do you have any links to previous threads or any articles that I can read up on to make sure I'm doing this correctly? Particularly anything with screenshots of the relationships, etc, so this newbie can compare notes.
I have a few external links that I'm looking through for information as well; would it be helpful to post those here?
Sorry, I don't have a good conditional value list demo available. Perhaps someone else can offer a demo file?
"I have a few external links that I'm looking through for information as well; would it be helpful to post those here?"
I don't know as I don't know what threads you've found.:smileywink:
If it helps you better explain your question, then please do so.
Here are the articles I'm looking through to see if they'll help (I don't know much about creating a table from values...):
I'm using a FMP file called July2010 School. In each Record, I have Fields for Name, Address, Email, etc, as well as Classes and information related to the classes. Right now, there's a separate FMP file that contains all the info for the classes; that FMP file is called July2010 Class Database, and each Record contains a class number, class name, class price, class date, and other info.
In July2010 School, when I enter a student's info, I type in what class numbers they're taking (as I mentioned, they can take up to 11, in the repeating fields), and that automatically populates the fields beside Class with the Class Name, Class Price, Class Date, etc--pulling that info from July2010 Class Database.
So, as I enter each class number, I would also like my Color field to populate with either a drop-down box (if there is a color choice for that class) or a blank box, or something similar.
Should I be putting the value lists for the colors into July2010 Class Database, with the records that contain the rest of the info for the classes?
I'd set up a "colors" table like this:
and so forth.
In Manage | Database | Relationships, set up a relationship that links ClassID in that table to ClassID in this color table.
I don't think you'll be able to get this to work if you are entering class numbers in a repeating field instead of a table of related records.