No fields in my subform.

[New_Access]

Hi All,
I have three tables.
1.Model_tbl
*) Product Name = Text ( PK )

2.Spec_tbl
*) Product Name = Text ( PK )
*) Power limit = Number
*) Ampere limit = Number
*)Airflow limit = Number
*)Date registered = Date/Time
*)Registrant = Text

3.Inspection Result_tbl
*)Product Name = Text
*)Production date code = Text
*)Inspection date = Date/Time
*)Inspector Name
*)Power value = Number
*)Ampere value = Number
*)Airflow value = Number

I want to create form.
..1.Inspection.

But how to design a good relationship from these 3 tables.?
I 'm getting dizzy from here.
I want to retrieve a record from Spect _tbl if a user want to input
an inspection result.I had designed a form and insert 'Inspection
Result_tbl_form' as a subform but I can't see any fields in my subfrom.
Why?.Please teach me agood basic.


Thank's.

 

[BruceM]

It's difficult to see just what you need to do without knowing a bit more
about the real-life situation behind the database. However, it seems maybe
that you manufacture and inspect some sort of product. I'm don't see the
need for three tables based on my limited understanding of your project. If
a product has a list of parts or manufacturing operations you would probably
have the product in one table, and the parts list or manufacturing
operations in a separate related table. A product could have any number of
parts or operations, so the related table for these details is part of good
relational database design. It does not seem that this is what you are
doing. From what I can tell the Specs and the Inspection Result are
attributes on the Product, and it could well be that you need just one
table, but as I said there is not enough information about the situation to
allow specific suggestions about the design.
I see that you have two other posts in this forum, one about a continuous
subform that you cannot add to the main form. Again, details are lacking
about, for instance, how you are trying to add it to the main form and what
happens when you try. Another thread is about hiding controls on the
subform based on the main form. In general, the way to reference a subform
control from the main form is Forms!FormName!SubformName.Form!ControlName.
Your questions suggest that some resources for review and study would be
helpful. This link is to a basic tutorial that provides a concise
explanation of database elements and how they work together:
http://allenbrowne.com/casu-22.html
This link takes you to a page with Tips for Casual Users, among other
things. I recommend browsing the articles.
http://allenbrowne.com/tips.html
Also, the same site contains a good list of links to articles, tutorials,
and so forth:
http://allenbrowne.com/links.html
The Access Web Page link is a good source of more information, but there are
many other fine sites listed.