Filtering Dynamic Value Lists : )

[Jhestler]

Hi All:

I'm sure this one is on the tip of my tongue...

I have two fields:

"Contact Type" which is located in a db called Contacts, and

"Performing Artist" which is located in a db called "Bookings."

When I select the "Performing Artist" field from withing the Bookings db, I would like to have a value list featuring the full names of all the Contacts who are of the Contact Type "Artist". the fullname field, by the way, is a concantenation of the 'first name' and 'last name fields' in the Contacts db.

is this possible?

kindest regards and thanks,

john

[Jhestler]

Figured it out; it was right under my nose...

Thanks anyway, everyone : )

John

[Kurt Knippel]

Start with a calculation field defined as "Artist". (i.e. cArtistFilter = "Artist")

Now create a relationship between the cArtistFilter field (in the Bookings file) and the ContactType field (in the Contacts file).

Finally create a value list based upon this relationship and showing the FullName field.

Once attached to your field in the bookings database you will see a list of the full names of all of the "Artists" in your contacts file.

P.S. This is just ONE way to accomplish this. Not necessarily the best or simplest approach, but it works pretty well for a very narrowly defined function as this.