is it possible to get the ID of a sub table ?
P

I have a table with some entry...I wish to get the contact in this table and find it s ID on the contact table.

the contact table is simply added to the actual table, not composite. It seem to give me the ID of the actual table only...

thanks!

Ninox Profile

Hi, 

You can get the ID of a record of a subtable or superior table. 

For the superior table (you can only refer to one record of that table in you current record) use:

 

contact.Id

 

For the subtable you need a condition of funktion to get a specific contact, as there can be more than one referred records in the subtable.

 

contact['Lastname' = "Jackman"].Id

or 

first(contact.Id)

Best regards, Jörg

Reply