Hi,

Here is my problem :

I have 2 database, one is for project, one is for a supplier list.

I'm trying to create a value list in the project database from active supplier in the supplier list database.

In the supplier list database, I have a field called Supplier Name and one for the State of supplier (active, hold, stop or never used) for the moment all these states are different field but eventually I would like to make it into one list.

What I want to do is have a list of only Active Supplier, the list would show Supplier Name field, in project database. I have tried many different thing without success, did any of you ever done this before.

Here is a little sample: You need some fields, two value lists and one relation.

DynList.zip

Two possible options

A) In the Supplier database create a new calc.

Case(IsEmpty(active),"",Supplier)

Set your value list in Projects to use values from this new field.

: Create a new Global field in Projects.

Create a relationship from Projects to Suppliers matching your new global field in Projects with "active" in Suppliers.

Set your value list to use related values, select your new relationship and supplier.

You will have to set the text "active" into your global field either by "burning" the value in a single user version or I would suggest running a start up script which populates this field every time the file is opened.

BTW. I think you're almost certainly right to combine your 4 status fields into one.

Thank you, it so simple, but it works that's what I like