Need help with Relationship and Linking forms/tables with buttons

[JKL123]

Hello, I'm currently learning how to use Access 2007 to create a database for some construction equipments. I've tried playing around with it myself but I couldn't figure it out at all even with some simple help from online tutorials. I'll quickly explain what I'm trying to do and see if anyone of you guys will be able to give me a hand.

1) A list of Construction Equipment which I've created in both Table and Form. (ex. the list would have Hydraulic Excavator, Loader, Bulldozer, etc.)
2) Since there are different types of Hydraulic Excavator, it is then split into Mini Hydraulic Excavator, Small, Large. (I want to make it so that the user can open the Construction Equipment Form, click a button specifically for Hydraulic Excavator and it should pop-up another form with the 3 sizes of Hydraulic Excavator)
3) Within the Large Hydraulic Excavator there are different Models of it and I would like to again open up another form which will have all the specifications of a certain Model within the Large Hydraulic Excavator table.

That's the general idea of what I'm trying to do. I'm not sure if I've explained myself well enough and I think it will be best if I actually send my Access database that I have so far for somebody to look over (or a screenshot of it.) I've tried building relationships between tables but I think I'm setting my database up completely wrong at the moment.

Please feel free to ask me for anything that you need to assist me with the database. Thanks!

 

[jackd]

Hello, I'm currently learning how to use Access 2007 to create a database for some construction equipments. I've tried playing around with it myself but I couldn't figure it out at all even with some simple help from online tutorials. I'll quickly explain what I'm trying to do and see if anyone of you guys will be able to give me a hand.

1) A list of Construction Equipment which I've created in both Table and Form. (ex. the list would have Hydraulic Excavator, Loader, Bulldozer, etc.)
2) Since there are different types of Hydraulic Excavator, it is then split into Mini Hydraulic Excavator, Small, Large. (I want to make it so that the user can open the Construction Equipment Form, click a button specifically for Hydraulic Excavator and it should pop-up another form with the 3 sizes of Hydraulic Excavator)
3) Within the Large Hydraulic Excavator there are different Models of it and I would like to again open up another form which will have all the specifications of a certain Model within the Large Hydraulic Excavator table.

That's the general idea of what I'm trying to do. I'm not sure if I've explained myself well enough and I think it will be best if I actually send my Access database that I have so far for somebody to look over (or a screenshot of it.) I've tried building relationships between tables but I think I'm setting my database up completely wrong at the moment.

Please feel free to ask me for anything that you need to assist me with the database. Thanks!

I suggest you do some searching on the topic of
Data Normalization, or Relational design as a start.

Here is a link, but there are many others.

http://r937.com/relational.html

 

[JKL123]

I suggest you do some searching on the topic of
Data Normalization, or Relational design as a start.

Here is a link, but there are many others.

http://r937.com/relational.html

Thanks for the link jackd, I'll read through it and see if I can solve some of my problems.

As of now I attempted to build a relation from Table1 to Table2, and Table 2 to Table 3. Table 1 to 2 is connected by an ID column that is common in both Tables, and a Sub-ID column connects Table 2 and 3.

When I start building Forms out of these Tables, I'm having trouble using buttons to open up specific form from the whichever entry the users selected. (ex. Table one has a list of Equipment Name, when I select Equipment 4 of 10 by clicking a button inserted in Form 1, I would like that the form for Entry 4 [which is another form I made with specific parameters] to open up.)

I'm not quite sure if I need to use the Code or Macro function to do it or are there any more user-friendly way to visually select tasks for specific buttons within a form?

 

[jackd]

Thanks for the link jackd, I'll read through it and see if I can solve some of my problems.

As of now I attempted to build a relation from Table1 to Table2, and Table 2 to Table 3. Table 1 to 2 is connected by an ID column that is common in both Tables, and a Sub-ID column connects Table 2 and 3.

When I start building Forms out of these Tables, I'm having trouble using buttons to open up specific form from the whichever entry the users selected. (ex. Table one has a list of Equipment Name, when I select Equipment 4 of 10 by clicking a button inserted in Form 1, I would like that the form for Entry 4 [which is another form I made with specific parameters] to open up.)

I'm not quite sure if I need to use the Code or Macro function to do it or are there any more user-friendly way to visually select tasks for specific buttons within a form?

I'm not exactly sure of what you're trying to do and where it fits into your overall application.
Is this a practice exercise, or is it part of some business?
Can you describe where this all fits? How about showing your table structures?

Here is another link to some tutorials/samples which may be appropriate.
http://www.fontstuff.com/siteindex.htm#access