Value lists from another database

[Dolly]

Hello,

I'm stuck and my head is now hurting. Unfortunately I normally work with traditional RDBMS' and so I'm in that frame of mind. I'm sure FMP can do the business for me but I'm really lost.

I have a table (keywords) it has two fields (keywordCategory, keywordEntry).

I would like to define a valueList based on a group of documents where the keywordCagtegory field matches.

ie:

keywordCategory keywordEntry

Gender Male

Gender Female

Status Current

Status Archive

Status Delete

From this i'd like to have two ValueLists (Gender & Status).

My reasons are that I want the ValueLists to be outside of the database design, as I can see many updates to the lists being made.

I wrote a script that updated some global fields with the values. But then learned that global fields can not be indexed. AAARRRGGGHHH.

Please can someone help.

Thanks

Dolly

[The Bridge]

If I understand correctly, you want the records in the keywords database to populate various (in this case, 2) valuelists in other databases.

One option is to define calculation fields (text result) in your main database, e.g.:

Keyword_Status = "Status"

and

Keyword_Gender = "Gender"

Then define relationships from Keyword_Status in your main db to keywordCategory in your keywords db. Base your Status valuelist on that relationship, pulling the values from keywordEntry.

Do the same for Keyword_Gender.

This will work with FMP 5 and later.

Hope this helps

[Dolly]

That is fabulous.

It worked straight away.

Oh many thanks. I knew the FMP should be able to do it. I just needed to forget RDBMS'.

Thanks

Dolly.

[The Bridge]

I'm happy I was able to help, Dolly!

[Dolly]

Works fine in a FM client. But using CDML ... nada.

Dam.

Any ideas anyone ?

[The Bridge]

You're right -- related value lists don't work with CDML.

What you can do is something like this:

[FMP-InlineAction:-DB=keywords&-Lay=layoutname&keywordCategory=gender&-Find]

[FMP-Record]

<option value="[FMP-Field:keywordEntry]">[FMP-Field:keywordEntry]

[/FMP-Record]

[/FMP-InlineAction]

[Dolly]

Bingo.

Peter. Hat's off to you.

Dolly.

[xtrim]

Hi

I have almost the same problem.

I have a value list that it's values are from a related table.

I am unable to display it.

DB1 = systems, Field=ID

DB2 = Users , Value_list=active , Lay=Web_main

How can I display the value list using "Inline" in CDML??