Hi! I have 2 UTD tables. Is there a way of connecting them if one of the columns is the same?

Table 1: client number | client name | url | username | password

Table 2: client number | project number | project description | open/closed

I have for the same client. several project numbers as well as several clients. Can I have a column on Table 1 with another page which will show the Table 2 filtered for just that client number?

Thanks for any help.

Alessandra Davies

Sebastian is correct, there is no support for table relations, neither in UDT nor in form and List.

form and List itself  introduces the new token querystring, which would allow you to call page 2 with a querystring parameter ?cl_nr=4711 and to add a filter "[client number] = [Querystring:cl_nr]".

No, use a calculated column.