Ceating a value list from related tables

[Filip Langenbick]

Hi,

 

I've have a database with 3 tables

 

a// contract (all contract per clients)

b// client base (all personal info of the client)

c// company base (the company information)

 

 

in the client base I created a calculation field:

 

Company:CompanyName & Name

 

this last field i need to use as a value list in the contract base

but it won't allow me because i can't index it

 

how can i find a solution for this problem?

 

I've tried a lot, but i can't solve it

Is someone able to help me?

 

Thank you very much

Filip Langenbick

[fmbug]

Hi Filip,

 

Take a global field in the both the table of which you want to create the value list. And in this field insert it with a value 1 in both of them. Then make the relationship between these two tables using that global field.

Now your value list is ready.

 

Let me know if you need more assistance.

[eos]

Take a global field in the both the table of which you want to create the value list. And in this field insert it with a value 1 in both of them. Then make the relationship between these two tables using that global field.

 

That's seems like a neat trick! Could you post an example database to show how this works?

 

Filip –

 

I've have a database with 3 tables

 

a// contract (all contract per clients)

b// client base (all personal info of the client)

c// company base (the company information)

 

in contact I created a calculation field:

 

Company:CompanyName & Name

 

– where will you need this value list? And what is 'Contact'? Are there more than three tables?

 

I suggest you post a copy of your file and/or tell more about your setup, and what you want to achieve.

[Filip Langenbick]

Hi,
this is the first base
here I store all my contracts
it's linked to an external base contact (in yellow)
here i need a value list showing: Company & Full Name
(image: base1.gif)
  
This is the second base where the tables contacts (ochre) an company (green) are defined.
The value list is a combination of
the company (out of the company table) and the name (out of the contact table)
 
Apparently this is not possible because i can't index a calculated field
 
(image: base2.gif)

 

Txk,

Filip

[Filip Langenbick]

I found this sollution on the internet, but I can't figure out how to do it.

Can some help me?

 

 

Create a Value-List in FileMaker from an unstored calculation field

Normally when ever we are trying to create a Value-List using the values from an unstored calculation field, FileMaker shows a message that says "The Value-List will not work because the field can not be indexed". If we ignore that message and the Value-List gets created then most of the time it will not display any value if used in a drop-down list..

But there is a simple way to overcome this situation. Just create a relationship to the table which has the calculation field and then use the calculation field from the related table occurrence in the Value-List, also select the option "Include only related values" as appropriate. Now this Value-List will work fine if used in a drop-down list.

 

Txk,

Filip

[eos]

Just create a utility relationship from any table to your join table, then use that path in the Value List definition. Here's an example.

UnstoredVL_eos.fp7.zip