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