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:
custid
Firstname
Lastname
Address
Address2
City
State
Zip
Phone
Email
And table RMA
Rmaid
Assignedto
Loggedby
Customerid
Date
Timespent
Status
Priority
Closedby
Completedby
Dateclosed
Billable
Billed
Cost
Lastmodifiedby
Lastmodifieddate
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
appriciated
