Page 2 of 2

Re: newbie - v4.5 lookup into another file - display

Posted: Mon Aug 16, 2021 3:44 pm
by 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

Re: newbie - v4.5 lookup into another file - display

Posted: Mon Aug 16, 2021 4:52 pm
by kev1n
In the Browse form, you also need to set the format.

Re: newbie - v4.5 lookup into another file - display

Posted: Mon Aug 16, 2021 4:54 pm
by 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).

Re: newbie - v4.5 lookup into another file - display

Posted: Mon Aug 16, 2021 7:34 pm
by Mike1961
kev1n wrote:In the Browse form, you also need to set the format.
perfect ! I missed this one. Obviously, that explanation solved the decimal problem too !

Re: newbie - v4.5 lookup into another file - display

Posted: Mon Aug 16, 2021 8:01 pm
by Mike1961
kev1n wrote: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

Re: newbie - v4.5 lookup into another file - display

Posted: Mon Aug 16, 2021 8:30 pm
by 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)?