If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
SubForm, or something Else?
I have Chosen (big Grin) to utilize the new Multivalued fields option offered
in Access 2007. But, as always, I get started very excited, but am unable to finish... Not sure how to design my Form - but it would be a Main Form Sub Form With ChurchID (as Main) and a Subform with PositionTitle1 (Non-repeating) (Indented) MinisterName1 (Indented) MinisterName2 (Indented) MinisterName3 PositionTitle2 (Non-repeating) (Indented) MinisterName1 (Indented) MinisterName2 (Indented) MinisterName3 I'm totally confused as to how to proceed... Can anyone assist? Here is my Query (easy and straight forward) qryTieChurchNeedsToMinister ChurchID, PosTitle, tblMinisterAssignment.MinisterLastNameFirstName.Va lue 25, Music, Kirk Arthur 25, Music, James Braswell 25, Music, John Duke 25, Music, Brian Lee 25, Music, Tommy Valentine 25, Children, Matt Addington 25, Children, Chris Aho 25, Children, Joe Aldrich 25, Children, Michael Aldridge 25, Children, Allen Allen 25, Children, John Allen 25, Children, Anna Anderson 25, Children, Mary Carol Anderson 25, Children, Joshua Apple 25, Children, Kirk Arthur |
Thread Tools | |
Display Modes | |
|
|