2 Replies Latest reply on Feb 4, 2010 5:08 PM by philmodjunk

    I just can't figure out how to do it . . .



      I just can't figure out how to do it . . .


      I am trying to create a database for the church I pastor.


      In the main table I have columns for Family Name, Head of House, Spouse, and six for "Child 1," "Child 2," etc., as well as address, city, state, etc.


      Now, one of the things I am trying to do is to create a membership directory.  I created a layout that had a field for "Last Name" and a merge field for "Head of House" and "Spouse."  Both work beautifully.


      Then, I set about trying gather the names of the children.


      First of all, I tried a merge, using the names of each of the Child fields.  It worked, but as soon as it ran out of fields with anything in them, it then inserted illipses after the list of names,  Then I tried just inserting the fields in the report and sliding them.  No matter what I did, once there were empty fields, I ended up with varying sizes of blank lines before the next family.  


      I am really frustrated, because I need this for a meeting on this next Tuesday.


      Any ideas how I can do this.  I am sure there is a simple fix, I just haven't found it yet.


      Thanks in advance for your help,


      Sincerely, Dan M. Appel (RevMoose)

        • 1. Re: I just can't figure out how to do it . . .

          you have a member

          Member Table (each member has unique ID - MemberTable:memberID

          members have signific others (only one)

          Included in the Member Table

          members have none or more children

          Children Table (each entry has a unique ID - AND a memberID ChildrenTable:memberID)

          this relates the childern to the member

          If the member has two phone numbers (some have four)

          you either create memberphone01, memberphone02, memberphone03....

          OR you create a Phone Table with a PhoneTable:memberID

          and allow none or more phonenumbers for each member 

          • 2. Re: I just can't figure out how to do it . . .

            First the quick fix:


            Sliding fields will do this if you pay attention to details:


            Select the "also reduce size of enclosing part option" for all the sliding fields.


            Select sliding for all fields and other layout objects that are even with or below you children fields.


            Check you layout in preview mode. The sliding won't be evident in browse mode but will take affect in preview or when you print.


            Longer fix for after your meeting:


            Look up portals and figure out how to enter you children data into a related table.