Hi Guys
I am busy trying to set up a database for machines, so it looks like this.
I want to have a list of Companies with all the details:
-Name, type, location etc
I want to be able to add Machines to companies with the following details:
- name, type, manufacturer, name of manufacturer
Now each company is split into 1 of 2 category of companies: Glass Processing (GP) or Aluminium Fabrication (AF), based on that category the machine type may vary.
So i would like to be able to allocate machines based on the category of companies.
So I have the following form: >>> addform.jpg
It is quite difficult to explain, but I hope you can get the gist of what I am trying to do.
SO there are 2 types of companies, AF & GP, and that drives the classification of the companies and machines....So when I click on my Add a Machine, I would like to be able to select the company I am adding a machine to and then all machines for that category would be listed, as well as the specific types of machines applicable to that category.
Yeah this is quite hard to put down on paper (um....internet)...
Hopefully someone can grasp what I am doing.
If you would like to see my full database i can send it to u.
Thanks in advance.
Regards
I am busy trying to set up a database for machines, so it looks like this.
I want to have a list of Companies with all the details:
-Name, type, location etc
I want to be able to add Machines to companies with the following details:
- name, type, manufacturer, name of manufacturer
Now each company is split into 1 of 2 category of companies: Glass Processing (GP) or Aluminium Fabrication (AF), based on that category the machine type may vary.
So i would like to be able to allocate machines based on the category of companies.
So I have the following form: >>> addform.jpg
It is quite difficult to explain, but I hope you can get the gist of what I am trying to do.
SO there are 2 types of companies, AF & GP, and that drives the classification of the companies and machines....So when I click on my Add a Machine, I would like to be able to select the company I am adding a machine to and then all machines for that category would be listed, as well as the specific types of machines applicable to that category.
Yeah this is quite hard to put down on paper (um....internet)...
Hopefully someone can grasp what I am doing.
If you would like to see my full database i can send it to u.
Thanks in advance.
Regards