Forum Discussion
PaulPeterson1
5 years agoQrew Assistant Captain
Can you provide a little more information? Please describe the relationship (which is parent and which is child) and what you have done so far.
------------------------------
Paul Peterson
------------------------------
------------------------------
Paul Peterson
------------------------------
- TaoufikBeghdadi5 years agoQrew MemberI 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
------------------------------- PaulPeterson15 years agoQrew Assistant CaptainI 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
------------------------------