display on browse form

[johan]

Hi
I have a problem when I want to display 2 items with the same name on a browse form.

Screenshot 2023-03-27 12.59.39.png

My SQL

Code: Select all

select a.re_id, l2.name afdeling , l.name functie, m1.naam titularis, m2.naam vervanger from contracten a
inner join list l on l.id = a.re_functie
inner join list l2 on l2.id = a.re_afdeling
left join titularis b on a.re_id = b.contract_id
left join medewerkers m1 on m1.id = b.medewerker 
left join vervanging c on c.vv_contract_id = a.re_id and c.vv_parent_id = b.medewerker 
left join medewerkers m2 on m2.id = c.vv_medewerker 
where b.eind is NULL and c.vv_eind is NULL

How can I solve this?

[kev1n]

Use an alias for the 2nd field to display:

e.g.

Code: Select all

M2.namm as naam2