Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / December 2007

Tip: Looking for answers? Try searching our database.

No fields in my subform.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
New_Access - 07 Dec 2007 07:31 GMT
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 - 07 Dec 2007 12:39 GMT
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.

> Hi All,
> I have three tables.
[quoted text clipped - 29 lines]
>
> Thank's.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.