I am creating a database to keep track of our warranty returns.
Currently we do not have anything to track warranty info besides a big
excel file. I would like to keep customer data, product info and RMA
data in separate tables but still keep them related.
If I had table customers:
And table RMA
What I want to ensure is that if john smith fills out an RMA request
online a customer id is assigned to John, the RMA number is associated
with Johns customerid and I need to figure out how to assign a product
to John. Also if john has more than one product assign products so when
I pull up Johns information I can see all of Johns products owned.
I am running mysql latest version.. Any help would be greatly