John;
The key fields for the "Parent" tables are an auto number, however I have a number field in each "parent" forms table called "idCollectionInfo" This needs the value of the subforms table Key field "IDCollectionsInfo" also an auto number field to link the 2 records together.
(sorry I use the same names I just capitalize "ID" when it is a key field)
Apparently I need some sort of query inserting that subform key field value "IDCollectionInfo" into the parent forms table receiving field "idCollectionInfo"
I don't know just how to format the query or what event on the parent form to place it into.
Walter
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Walter-
>
> I need to see the structure of the two tables - at least the relevant key
> fields. What is the Primary Key of one of the "Parent" tables, and what is the
> Primary Key of the "Child" table?
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of nkpberk
> Sent: Wednesday, June 29, 2011 4:54 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Playing with subforms again
>
> John;
> I should probably note that the data entry on the subform works BUT I cannot
> figure out how to get the subforms record ID to append to the parent form. The
> data is there and if I "plug in" the record ID manually into the parent forms
> table (In spreadsheet mode) when I review the form view it works (but that's
> seriously impractical ;-)
> Walter
>
> --- In MS_Access_Professionals@yahoogroups.com, "nkpberk" <wgriffin48@>
> wrote:
> >
> >
> >
> > John:
> > The "parent" form contains information about the Item being inventoried.
> Currently there are 3 "parent" forms, Book, media and periodical containing data
> like title, author, subjects etc.. Each "parent" form has a different table
> because the inventories have different table/field structures. I am trying to
> use a subform (the same subform) on all three "parent" forms containing data
> such as cost ,condition, location/disposition etc.. as this data is the same
> across all items in the library. So as to not duplicate all those data fields in
> each table I thought I could link a "collectionInfo" table to each record in the
> "Inventory" tables and thereby append only an "IDCollectionInfo" field to the
> tables populating the "parent" forms. The relationship is 1 to 1 as the
> collectionInfo records are specific to each inventory item.
> > I hope that makes sense. The plan seems valid to me.
> > Walter Griffin
> >
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> > >
> > > Walter-
> > >
> > > I'm having a hard time picturing this. What is the structure of the two
> tables?
> > > Which is the "parent" table in the 1-1 relationship?
> > >
> > >
> > > John Viescas, author
> > > Microsoft Office Access 2010 Inside Out
> > > Microsoft Office Access 2007 Inside Out
> > > Building Microsoft Access Applications
> > > Microsoft Office Access 2003 Inside Out
> > > SQL Queries for Mere Mortals
> > > http://www.viescas.com/
> > > (Paris, France)
> > >
> > >
> > > -----Original Message-----
> > > From: MS_Access_Professionals@yahoogroups.com
> > > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of nkpberk
> > > Sent: Wednesday, June 29, 2011 2:16 AM
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Subject: [MS_AccessPros] Playing with subforms again
> > >
> > > Hello Group;
> > > trying something with a subform that's a bit different.
> > > I have a some forms which all share the some of the same data.
> > > this is a library/collections app, where I am segregating the common data to
> a
> > > subform I can use in each mainform. This is a 1 to 1 relationship. I am
> doing
> > > this so I don't have to reinvent the wheel on every data entry form and
> > > duplicate the data.
> > > I have made a "CollectionInfo" field in the table for the main form and it
> > > should contain the value of IDCollectionInfo" from the table in the subform.
> > > The subform wiz want to link these backwards (subform field to equal
> mainform
> > > field) the mainform field is nada! How do I make these play nice?
> > > Walter Griffin
> > >
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Yahoo! Groups Links
> > >
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
Tidak ada komentar:
Posting Komentar