newbie - v4.5 lookup into another file - display

[Mike1961]

Hi Kevin and thank you for your help.
I'll record the video while editing a task
In the meantine, here is several pics about the problems

Thank you

[kev1n]

In the Browse form, you also need to set the format.

[kev1n]

What is the data type for "Compagnie" in the database table? Is "Compagnie" stored to the table when first saved (check in the db table directly).

[Mike1961]

In the Browse form, you also need to set the format.

perfect ! I missed this one. Obviously, that explanation solved the decimal problem too !

[Mike1961]

What is the data type for "Compagnie" in the database table? Is "Compagnie" stored to the table when first saved (check in the db table directly).

varchar(1000)

compagnies data.jpg

And yes, when I add data into Compagnie DB, all fields are filled
When I add a task and pick a company, I can pick the acronym and display all the related data.
when I look at the db (browsing), I have acronym (I don't need to display the company name at that point), company phone and contact. I submitted a PM with the video to describe the effect when I want to edit a task (loosing the acronym and data)

task db.jpg

[kev1n]

I really can't say what's going wrong without seeing the form. Could you use the "Cloner" to send me the form's SQL and also a dump of your two tables (maybe add 1-2 dummy rows)?