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 / April 2006

Tip: Looking for answers? Try searching our database.

2subforms

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
babs - 29 Apr 2006 13:40 GMT
I have two forms where I would like to see all records for a GIVEN on the one
one screen - but two tables- tied together with a common field.  Right now I
have one as a main form and one as a subform.  The subform is fine but the
main form ony show ONE record for the day.  Would like to see all records for
given day - on main form( or do need to make it  a subform).  Not sure how to
have 2 subform tied together on a Form.

Please help,
Barb
G. Vaught - 29 Apr 2006 22:47 GMT
In a main form / sub form scenario the main forms primary key resides in the
subform as a foreign key. This will relate all the subform data to the main
form. The main form should only show one record, the subform is the one that
should show multiple records.

For example I am a customer of XYZ company. When they call up me in the main
form, the subform will show all the orders I placed. Thus, the one to many
relationship.

If you are not getting the data you want, then either your table design(s)
is/are incorrect or your design of your mainform / subform is backwards.

>I have two forms where I would like to see all records for a GIVEN on the
>one
[quoted text clipped - 9 lines]
> Please help,
> Barb
 
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.