Rabu, 29 Juni 2011

RE: [MS_AccessPros] Playing with subforms again

 

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

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar