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
> >
>
Tidak ada komentar:
Posting Komentar