Jump to content

Value in one field defining value list for 2nd?


This topic is 6546 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

im an extreme newbie trying to create a database for my middle school classes. i teach lot of different classes, so in logging my information i was wondering if there is a way to have the value of the 'grade field' (which is a drop down list from 5-8) define which value list will be used in the 'teacher' field, thereby minimizing the number of names that need to be scrolled through. for instance, once 6 is chosen (as in 6th grade) only the value list with 6th grade teacher names is available for the 'teacher' field. alternatively, if 7 is chosen, only 7th grade teacher names are available in the 'teacher' field.

i just began using filemaker pro 5 last night, so my familiarity is limited. will a script be required or is there an easier strategy?

thanks for any help

Link to comment
Share on other sites

I can't remember when this feature became available, so it may not be possible in your case. But, in FileMaker 6, you can do it this way:

create a second file, call it "students.fp5". Each record contains a student's name and his/her grade.

Then, in the main file, create a relationship to Students.fp5. It should be defined as follows:

Grade ::= Grade

That is, relate the Grade field in your main file to the Grade field in the Students file.

Then, change your students value list to use "Values from Field". You should get another dialog where you can specify "Only Related Values" and select the relationship you want to use (in this case "Students").

(The "Only Related Values" option is the part that I'm not sure exists in FileMaker 5.0).

When you specify a grade in the main file, the value list for the students' names should only contain those in that grade.


Link to comment
Share on other sites

  • 2 weeks later...


This is kind of a dumb question but could you tell me what the protocol is behind the suffix ".fp5". I see this appendage added to lots of file names but I'm not sure why.



Link to comment
Share on other sites

FMP 5.0, 5.5 and 6.0 all share the same file format. Earlier versions use a different format (there are several depending on the version). For instance FMP 3.0, 4.0 and 4.1 use the same file format. These files have ".fp3" extension, whereas the newer files have ".fp5" to differentiate them.

It's strictly not necessary on Macintosh systems but is needed in Windows because it uses the extension to associate the program used to open it.

Link to comment
Share on other sites

This topic is 6546 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

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