Grouping in a list? 
Author Message
 Grouping in a list?


Quote:

> How can I create groups in a list view? I have one file that is the
> related file, containing the various infos belonging to a client file.
> The relationship looks like this

> Main: Client ID -> History: Client ID

> History contains the info, Main, the names.

> What I want to create looks like this

> Joe Smith
>   Item 1
>   Item 2
>   Item 3

> Jane Brown
>   Item 1
>   Item 2
>   Item 3

> Sure would appreciate the input!

> Thanks.

> --
> Zeph
> framar(at)interlog(dot)com

Zeph,

If I understand your request, can't you just stack the fields you want to
group in the Body of a layout, such as:

NameField
  Item 1 Field (from relationship)
  Item 2 Field (from relationship)
  Item 3 Field (from relationship)

Close up the Body as much as you can then choose View as List in Browse
Mode.  Multi-line "browses" in FileMaker Pro can be quite useful (and
difficult or impossible to do with other databases.)  You will then be able
to scroll though all you records and see info from the related file (you can
use a portal too - put a scroll bar on your portal and you can scroll
through each portal as well as your whole list.)

If this doesn't fill your requirement, what else are you looking for?

Jim



Thu, 12 Sep 2002 03:00:00 GMT
 Grouping in a list?

Quote:



> > How can I create groups in a list view? I have one file that is the
> > related file, containing the various infos belonging to a client file.
> > The relationship looks like this

> > Main: Client ID -> History: Client ID

> > History contains the info, Main, the names.

> > What I want to create looks like this

> > Joe Smith
> >   Item 1
> >   Item 2
> >   Item 3

> > Jane Brown
> >   Item 1
> >   Item 2
> >   Item 3

> > Sure would appreciate the input!

> > Thanks.

> > --
> > Zeph
> > framar(at)interlog(dot)com

> Zeph,

> If I understand your request, can't you just stack the fields you want to
> group in the Body of a layout, such as:

> NameField
>   Item 1 Field (from relationship)
>   Item 2 Field (from relationship)
>   Item 3 Field (from relationship)

> Close up the Body as much as you can then choose View as List in Browse
> Mode.  Multi-line "browses" in FileMaker Pro can be quite useful (and
> difficult or impossible to do with other databases.)  You will then be able
> to scroll though all you records and see info from the related file (you can
> use a portal too - put a scroll bar on your portal and you can scroll
> through each portal as well as your whole list.)

> If this doesn't fill your requirement, what else are you looking for?

I would guess subsummaries.
In the Info file, create a subsummary Part based on Client ID. Put the
client name in this, and the item in the body. When the file is sorted
by client ID, it will appear in the form above. You have to go to
Preview Mode to see it. This is most suitable for printing.
--
Mire Black


Fri, 13 Sep 2002 03:00:00 GMT
 Grouping in a list?
You could stack the fields
Name
   related::item 1
   ...
   related::item n

and use sliding to make those records with fewer items print shorter. It
doesn't help with the screen view.

-myth


Quote:



>>If this doesn't fill your requirement, what else are you looking for?

>Sorry, I should have specified: There can be any number of related
>records to a client. One may have only three, but another thirty three.
>A portal is one way of doing it, but it's not quite as elegant as I
>would like, seeing as I'm still limited to the number of row in a
>portal.  Now If I could dynamically set the number of portal rows (ie:
>number of rows equals status(recordCount) that would be a neat trick.
>Don't know if that's do-able though. Thoughts?

>I should have said it this way:

>John Smith
>  item 1
>  item 2

>Jane Doe
>  item 1
>  item 2
>  item 3
>  item 4

>Harry Browne
>  item 1

--



Fri, 13 Sep 2002 03:00:00 GMT
 Grouping in a list?
Provide me a valid e-mail account and I'll mail you some example files....

Robert Farkas
Systems Engineer


Quote:

> How can I create groups in a list view? I have one file that is the
> related file, containing the various infos belonging to a client file.
> The relationship looks like this

> Main: Client ID -> History: Client ID

> History contains the info, Main, the names.

> What I want to create looks like this

> Joe Smith
>   Item 1
>   Item 2
>   Item 3

> Jane Brown
>   Item 1
>   Item 2
>   Item 3

> Sure would appreciate the input!

> Thanks.

> --
> Zeph
> framar(at)interlog(dot)com



Fri, 13 Sep 2002 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. USER GROUP OR MAIL LIST FOR ADABAS

2. BASISPlus news group or mail list?

3. Wanted: SQL BBS list and User Groups list

4. Rolling Up a Group (or, Grouping a Group)

5. GROUP BY and the SELECT list

6. group over list

7. getting a list of groups a specific user belongs to in sql server 2000

8. SQL Script list Windows group userids

9. SQL script that will list userids in windows group

10. List all tables/Indexes in a file group

11. Listing Users in NT Groups


 
Powered by phpBB® Forum Software