I have searched the posts but I haven't found the answer that I am looking for. I have 3 Databases Company, Location and Contact.

They are relatated as follows:

Location::CompanyID - Company::CompanyID

Contact::CompanyID - Company::CompanyID

Contact::LocationID - Location::LocationID

Ok my problem is this. I would like to be able to select a location for each contact. I only need the locations for the company to show up.

This works just fine in the DB, but when I attempt this thru CDML it does not work. I've been trying to do this through [FMP-ValueList]. I've used valuelists in other places and it works just fine. What am I missing?

Relation Value Lists are not working on web. The ones, which show, related values.

Ways exist of doing this with the [FMP-InlineAction] tags. However, it depends on how your page is organised.

All the best.

Garry

Sorry for the late reply.

I actually can get the InlineAction to work but not in a select statement. Is there a special way to do this?

Thanks.