Machine Database

cfraser

New member
Local time
Today, 11:04
Joined
Jan 16, 2013
Messages
3
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
 

Attachments

  • AddForm.jpg
    AddForm.jpg
    20.8 KB · Views: 110
  • Microsoft Access - Machines Database  Database (Access 2007 - 2010).jpg
    Microsoft Access - Machines Database Database (Access 2007 - 2010).jpg
    41 KB · Views: 109
You should Not use Id by itself as the Id of a table. (not mandatory but a reasonably good practice)
It gets confusing, and requires some discriminating (tableName) reference. In your company table, change ID to CompanyID.
In your Machines table, remove company name, make a new field CompanyId datatype number as a foreign key to the CompanyTable.
Do your relationships on numeric keys (generally).
Every table should have a Primary Key (MachineType does not). Create a PK.

Get your tables designed and relationships set up to meet your needs. Test your data model with sample data. The key to data base is the underlying structure - tables and relationships.

This article could be very useful to you.
http://www.rogersaccesslibrary.com/Tutorials/Entity_Relationship.zip

Good luck with your project.
 

Users who are viewing this thread

Back
Top Bottom