I need to compare 2 fields of 2 different tables and get a result like conform/not conform in a listbox.
I created a form with 2 listbox:
- the first one displays information of the original field with the field to compare
- the second one displays information of the field to confirm the entity of the first listbox
In the second listbox, I added a column as boolean and added this expression: Form.EntitySelection1.Checksum=Form.EntitySelection2.XTexte
The 2 listbox contains absolutly the same number of record and both are sorted with the same criteria.
So, record m of Listbox 1 is linked to record n of listbox 2.