Forum Discussion
TaoufikBeghdadi
5 years agoQrew Member
I did not establish a relationship between the two tables yet. Both tables contain invoicing data, and I want to find a way to compare between the billing amounts in the two tables, and highlight discrepancies.
------------------------------
Taoufik Beggdadi
------------------------------
------------------------------
Taoufik Beggdadi
------------------------------
PaulPeterson1
5 years agoQrew Assistant Captain
I would create a relationship between the two tables, create lookup fields for the two columns you want to compare, then you could compare the lookup values from the parent table to the values in the child table
------------------------------
Paul Peterson
------------------------------
------------------------------
Paul Peterson
------------------------------