Ok, a little background.
Each person in my database has a unique record. In each record I would like to make a history of purchases for that person.
In a different database, I have records of all past purchases. However, I have no common relationship between the two databases.
My thought is that if the addresses match exactly, or even the phone numbers, then automatically input their purchase/s into the fields I have made....
Any thoughts on how to do this? Is there an easier way that I'm over looking?
Thank you!
Each person in my database has a unique record. In each record I would like to make a history of purchases for that person.
In a different database, I have records of all past purchases. However, I have no common relationship between the two databases.
My thought is that if the addresses match exactly, or even the phone numbers, then automatically input their purchase/s into the fields I have made....
Any thoughts on how to do this? Is there an easier way that I'm over looking?
Thank you!
