Hello, I'm working on a database for a PC repair service and I need help. I'm really bad at organizing tables and relationships (also I'm failry new to access so bare in mind I have no experience, I have read and watched some basic tutorials).
I have few questions, I hope you will answer:
So basicaly I want to be able to track costumer / company to work orders - the thing is, the information is different, company info has more of information whereas customer (person) info has less.
So I've made two tables with similar values:
tblCustomer and tblCompany (I'm not sure is this the most optimized way to do it)
Now for the important part: I would like to have a "work order" where I can enter info about service done to that particular customer / company. So I 've created a form frmWorkOrder where I can input said information. The form should contain customer info and PC repair info.
I would like to choose a customer/company from a dropdown list and have the form auto filled (customer info) then I would input repair information. Also I would like to have a customer / company repair history.
I hope I was clear enough, If you need more info I would be happy to provide.
What is the best way to do this? Any tips / links would be highly welcome.
Thanks in advance.
I have few questions, I hope you will answer:
So basicaly I want to be able to track costumer / company to work orders - the thing is, the information is different, company info has more of information whereas customer (person) info has less.
So I've made two tables with similar values:
tblCustomer and tblCompany (I'm not sure is this the most optimized way to do it)
Now for the important part: I would like to have a "work order" where I can enter info about service done to that particular customer / company. So I 've created a form frmWorkOrder where I can input said information. The form should contain customer info and PC repair info.
I would like to choose a customer/company from a dropdown list and have the form auto filled (customer info) then I would input repair information. Also I would like to have a customer / company repair history.
I hope I was clear enough, If you need more info I would be happy to provide.
What is the best way to do this? Any tips / links would be highly welcome.
Thanks in advance.
