Hello,
I have a custom table where I created a field Person with the same EDT DirPartyRecId in the properties as in the properties of the HCMWorker.Person field. Also I created relations to HCMWorker and other relations exactly as they are created on HCMWorker
I'd like my custom table's field's Person lookup to contain the same Persons as in HCMWorker but for some unknown reason it contains much more values. Some of them are from HCMWorker's Person field, some not. I also know that HCMWoker.Person field contains reference most likely to DirPErson.Name field via relations. IN table browser HCmWorker.Person field contains Names but the filed is int64 recid field.
I think that my lookup contains all values from DirPartyTable because EDT DirPartyRecId contains FormHelo DirPArtyLookup form and there is a route table DirPArtyTable inside.
How to build lookup for mytable.person so that it contains only values from HCMWorker.Person. With other tables I created it easily by creating relations and nothing more. But here it doesn't work.
Thanks.
