Value List Data from ODBC PROBLEM

[Giancarlo Migoni]

Hi, I’m having troubles with value list, well let me explain a little bit about my project:

I have a database in SQL Server, with 3 tables:

1.- Vehicles Report

2.- Models (for example: BMW, AUDI, etc)

3.- Submodel (example: from audi: A3, A4, etc)

I connect to by database using ODBC, so I import al the fields in to my layouts, which it’s working great, I create a new record, and can see it in the Database without a problem.

The issue is that I need to enter a new Vehicle Report which has several fields, the once i need to work depending on each other are: Model and Submodel.

So I need to select the model (AUDI) from a Drop Down List, which has all the models, once selected the next field also it’s a drop down list which needs show only the Audi Submodels (A3,A4,etc).

The problem I have is, I can’t see following the steps:

Select Model Field > Field/Control Setup > Display Style: I selected Drop down list > Display Values from > Manage Value List > New > Use Values from Field > Use Values from First Field >>>>>> AND HERE IS THE PROBLEM !

I can see the Tables but in grey color (Shaded) , so I can’t select the table Model.

I check my Relationships And all are linked. So I have no idea what’s wrong.

If somebody an detailed answer I will appreciate it a lot !!

Best Regards

Gian

[corn]

I connect to by database using ODBC, so I import al the fields in to my layouts, which it’s working great, I create a new record, and can see it in the Database without a problem.

....

The problem I have is, I can’t see following the steps:

Select Model Field > Field/Control Setup > Display Style: I selected Drop down list > Display Values from > Manage Value List > New > Use Values from Field > Use Values from First Field >>>>>> AND HERE IS THE PROBLEM !

....

If somebody an detailed answer I will appreciate it a lot !!

ESS does not support creating value lists from external data.

You can, however, use portals and scripting to allow users to pick from a list similar to picking from a value list.

[Giancarlo Migoni]

Thanks, after all night long, trying, i figure it out that is not possible.

So what about this:

TABLES FROM SQL:

1.- db_Model (fields: db_modelID & db_model)

2.- db_Submodel(fields: submodelID & submodel)

TABLE IN FILEMAKER:

1.- fm_Model (fields: fm_modelID & model)

2.- fm_Submodel(fields: fm_submodelID & fm_submodel)

Then i create a relationship like this:

db_ModelID = fm_ModelID

what i'm trying to saiy is to duplicate the records stored in db_model and show in fm_model, so with this i can create the value list local, is that correct?