Hi guys,
I need some help on a formula that compares records
I have {table1}that has record ID like 1, 2, 3, 4 .....
In another table {table2}there is a field that uses the record ID from{table1} for a parent ID
So a record in {table2} will have a parent ID matching one of the record ID in {table.field1}
I need a formula (probably it will be a variable) that will run the parent ID field through the {table.field1} and when it finds the match to dislpay a meesage something like "match".
I hope I explained it so it can be understood.
Thanks in advance
I need some help on a formula that compares records
I have {table1}that has record ID like 1, 2, 3, 4 .....
In another table {table2}there is a field that uses the record ID from{table1} for a parent ID
So a record in {table2} will have a parent ID matching one of the record ID in {table.field1}
I need a formula (probably it will be a variable) that will run the parent ID field through the {table.field1} and when it finds the match to dislpay a meesage something like "match".
I hope I explained it so it can be understood.
Thanks in advance