creating a script to appear specific names

[emailaff]

Hi everyone!

I'm using a portal to manage my members of staff who work for me like: assistants, makeup artists, producers, etc.

I have two fields in this portal called "Type"(drop-down menu) and "Name"(drop-down menu) which means that in the"Type" field i'm placing the type of staff (makeup, producer, etc.), and in the "Name" field i'm placing the name of the staff related to that type of work.

Now, i do have a table just for my staffs registration, and what i want to do is; when i select the type of work in the "Type" field, in the "Name" field would appear only the names related to that type of work. For example: If i select in the "Type" field "Producer", when i'll click in the "Name" field it will only appears all the names of producers that i have register in my Staff Registration Table.

Please, i've tried to do it, but i only could make it appear all the names of my entire Staff Registration Table.

I'll be very very glad if somebody help me! Please!

Thank you for your time!

[Inky Phil]

You will need a relationship based on type = type.

Once you have created this a relationship you can nominate your value list for the field 'names' to show values from the field 'name' and check 'show related values only' and where it says 'starting from' you must nominate your new relationship.

Once all this is done only the names with the appropriate type will show in your list

hth

Phil

[emailaff]

Thanks man!

Could you be more especific?! I'm new to FMP.

What do you mean with a relationship type=type?

I have to create a new value list?

I'm far away to understand what you said.

Please, keep helping me!

Thank you very very much!

[Inky Phil]

Because I do not know the table names or structure that you have at the moment it would not be easy to explain any more specifically than I have already done.

If you can post a zipped copy of your file, or a clone of your file, I could then probably demontrate quite quickly what you need.

Phil

[emailaff]

Hi Phil!

I made it!

It was easier than i thought!

Thank you very very much for your time!

Best regards!

Edited March 27, 2008 by Guest