Using a relationship to join two tables.
I have two tables that I would like to join and then only show me the differences between the two tables. Basically, the two tables have all the same fields and have a lot of the same data. I get a ne...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendDo any of the tables have a unique field which can be used as the key field?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Yes, there are a combination of text fields that I would like to use as the key field. However, I have to concatenate them in order to get the unique identity. And, I know that you can't set a formula field as a key field. I could concatenate in Excel before uploading into QB if that is necessary.
--
--
- MarkShnier__YouIf you can set the Key field to be a unique Key buy changing your import process, then you can have a relationship where Table A is the Parent and joined to Table Based on a mirror formula field of the corresponding field in Table B. then look up all the fields from Table A to Table B.
Then to the same relationship and looks in reverse.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------