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