Hello AdminLike

I'm not sure if i have understood you correctly but. I recreated this as best as I can..

Data entry form (Test1) with a linked field (to table Locations - this table has just one combo box field in it)

 

Test1 Data entry Form 

Select a text option from Chi dropdown

 

Linked field (related field) is auto updated

 

Click on linked field and it pops up

 

So I placed the following script in - Trigger after update in the chi field

let ChiNo := number(Chi);
Locations := ChiNo

 

Does that give you what you want?

oh Good

Technically - Doing what you asked for gives rise to a potential issue insofare as it relys on having a combo box in your consulene table and a drop box in the data table field (chi) that needs to be the same. The issue is ensuring they are kept the same....

You could of course do it the other way around and use the related link field to find the item (ie Fran) and then have that field update the chi field with a TEXT extry thus having drop down data in one table ..

In this case you would change Chi field from drop down to a text field

and put this script in the trigger after update in Consulente related field.

Mel :-)

I didn't add the script !!! DOH!

let ChiNo := text(Locations.Consulente);
Chi := ChiNo