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 / General 2 / June 2007

Tip: Looking for answers? Try searching our database.

Subform items not saving

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
EngineerGuy - 20 Jun 2007 16:43 GMT
I am creating a new dbase that will be used similar to a bill of material
(BOM).  My problem resides with making the two primary Tables to interact
correctly together.  I have created a main data entry form and a Subform that
will be used inside the main Form.  The main form will be used to select
parent item numbers and the subform will be used to assign multiple component
items to the parent number.  Both the parent items and the component items
have their own separate tables.  I am creating my forms directly from the
Tables.  The parent table has a component field that is linked to the
component Table.  I have the parent form functioning properly and allowing me
to assign multiple components to the parent item number, however these
component numbers are not being saved when I return to the record number in
the form.  Please help!  Am I way off base or should I find a sample dbase to
use instead?  Thank you for any assistance that anyone can provide!
Jason Lepack - 20 Jun 2007 17:15 GMT
Email me with an address that I can send an example to.

> I am creating a new dbase that will be used similar to a bill of material
> (BOM).  My problem resides with making the two primary Tables to interact
[quoted text clipped - 9 lines]
> the form.  Please help!  Am I way off base or should I find a sample dbase to
> use instead?  Thank you for any assistance that anyone can provide!
Scott McDaniel - 20 Jun 2007 17:17 GMT
>I am creating a new dbase that will be used similar to a bill of material
>(BOM).  My problem resides with making the two primary Tables to interact
[quoted text clipped - 9 lines]
>the form.  Please help!  Am I way off base or should I find a sample dbase to
>use instead?  Thank you for any assistance that anyone can provide!

The Child should store the ParentID ... not the other way around. In your description, you say the "parent table has a
component field that is linked to the component table" ... this would mean that only ONE Component could be associated
with a single Parent. Instead:

tParent
------------
lParentID [PK]
sName
sOtherStuff

tComponents
----------------
lComponentID [PK]
lParentID [FK to tParent]
sName
etc etc

In this setup, you would use your Main form to show info on from tParent, and then use your subform to show info from
tComponents ... set th Master/Child link fields to lParentID, and you should be good

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
 
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.