Forum Discussion
HolliMills
Qrew Trainee
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__You
3 years agoQrew Legend
If 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
------------------------------
Then to the same relationship and looks in reverse.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------