Only one entry in summary

17 messages

Only one entry in summary

Reply Threaded

OK, I'm baffled again. Please have patience with this newbie. I've
got a list layout with data on individuals. When I enter the data in
the layout the summary pulls from for the first individual it shows up
fine in the summary layout. When I enter data for the second
individual, it doesn't show up, in any view in the summary layout.
Doing a find on the account number associated with the individual and
on the individual's name, I still get nothing. Does anyone have any
idea what I'm not doing or what I'm doing wrong?

Also, can anyone point me to a good tutorial on sub-summary and
trailing grand summary set up?

FM Pro Advanced 10

Thanks,
George

--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/

Colin MacGregor

Re: Only one entry in summary

Reply Threaded

If you haven't already done so, the FileMaker Help system is a good
place to start. Type Summary in the Help Search field and then start
with these topics - About Layout Part Types and Defining Summary fields.

There is a FileMaker tutorial pdf here:
http://www.filemaker.com/downloads/pdf/fmp9_tutorial.pdf (page 45)
This is still based on version 9, but it's still a good foundation for
10

There are also blogs at:
http://filemakerreports.blogspot.com/
http://filemakerweetbix.wordpress.com/2009/06/18/sub-summaries-and-displaying-of-total/

Kind regards,

Colin

+++

Colin MacGregor

Resolute Systems (UK) Limited
9 Marlow Road
High Wycombe
Bucks
HP11 1TA
UK

www.resolutesystems.co.uk

tel: 01494 520088
cell: 07974 152733
Skype: resysuk

registered in England and Wales
company registration number 3826934
VAT registration number 776 3622 04

FileMaker Business Alliance member
FileMaker TechNet member

On 28 Oct 2009, at 02:08, George R. Hozendorf wrote:

> OK, I'm baffled again. Please have patience with this newbie. I've
> got a list layout with data on individuals. When I enter the data
> in the layout the summary pulls from for the first individual it
> shows up fine in the summary layout. When I enter data for the
> second individual, it doesn't show up, in any view in the summary
> layout. Doing a find on the account number associated with the
> individual and on the individual's name, I still get nothing. Does
> anyone have any idea what I'm not doing or what I'm doing wrong?
>
> Also, can anyone point me to a good tutorial on sub-summary and
> trailing grand summary set up?
>
> FM Pro Advanced 10
>
> Thanks,
> George
> --
> This list is a free service of LassoSoft: http://www.LassoSoft.com/
> Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
> Manage your subscription: http://www.ListSearch.com/FileMaker/
>
>

George R. Hozendorf

Re: Only one entry in summary

Reply Threaded

Thanks, Colin

On Oct 28, 2009, at 10/28/09 - 3:57 AM, Colin MacGregor wrote:

> If you haven't already done so, the FileMaker Help system is a good
> place to start. Type Summary in the Help Search field and then start
> with these topics - About Layout Part Types and Defining Summary
> fields.
>
> There is a FileMaker tutorial pdf here:
> http://www.filemaker.com/downloads/pdf/fmp9_tutorial.pdf (page 45)
> This is still based on version 9, but it's still a good foundation
> for 10
>
> There are also blogs at:
> http://filemakerreports.blogspot.com/
> http://filemakerweetbix.wordpress.com/2009/06/18/sub-summaries-and-displaying-of-total/
>
> Kind regards,
>
> Colin
>
> +++
>
> Colin MacGregor
>
> Resolute Systems (UK) Limited
> 9 Marlow Road
> High Wycombe
> Bucks
> HP11 1TA
> UK
>
> www.resolutesystems.co.uk
>
> tel: 01494 520088
> cell: 07974 152733
> Skype: resysuk
>
> registered in England and Wales
> company registration number 3826934
> VAT registration number 776 3622 04
>
> FileMaker Business Alliance member
> FileMaker TechNet member
>
>
>
>
> On 28 Oct 2009, at 02:08, George R. Hozendorf wrote:
>
>> OK, I'm baffled again. Please have patience with this newbie.
>> I've got a list layout with data on individuals. When I enter the
>> data in the layout the summary pulls from for the first individual
>> it shows up fine in the summary layout. When I enter data for the
>> second individual, it doesn't show up, in any view in the summary
>> layout. Doing a find on the account number associated with the
>> individual and on the individual's name, I still get nothing. Does
>> anyone have any idea what I'm not doing or what I'm doing wrong?
>>
>> Also, can anyone point me to a good tutorial on sub-summary and
>> trailing grand summary set up?
>>
>> FM Pro Advanced 10
>>
>> Thanks,
>> George
>> --
>> This list is a free service of LassoSoft: http://www.LassoSoft.com/
>> Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
>> Manage your subscription: http://www.ListSearch.com/FileMaker/
>>
>>
>
>
> --
> This list is a free service of LassoSoft: http://www.LassoSoft.com/
> Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
> Manage your subscription: http://www.ListSearch.com/FileMaker/
>
>

VanBuskirk, Patricia

Re: Only one entry in summary

Reply Threaded

In reply to this post by George R. Hozendorf

Hi George,

I've been working with FMP for about 4 years now, and I still feel like
a newbie most of the time ... there is just so much to know! I have
always struggled with summaries, for some reason. So anyone else who
knows better, feel free to correct me here.

Summary fields on a layout (say in the footer) should always show the
totals for the records found (but can slow things down significantly).
A summary or grand summary set up in a layout part will only tally up in
preview mode.

I'm not sure what version of FileMaker you are using, but I have FM9A
and I have 2 books that I reference often for design information:
"FileMaker Pro 9 Bible" by Ray Cologon and "FileMaker Pro 9 The Missing
Manual" by Geoff Coffey & Susan Prosser. For descriptions and examples
of script steps and commands, etc., I constantly refer to "FileMaker 9
Developer Reference" by Bob Bowers, Steve Lane and Scott Love. I use
the heck out of that one! I got all three at Amazon.com.

HTH,
Trish

-----Original Message-----
From: FileMaker Talk [mailto:[hidden email]] On Behalf Of
George R. Hozendorf
Sent: Tuesday, October 27, 2009 10:09 PM
To: FileMaker Talk
Subject: Only one entry in summary

OK, I'm baffled again. Please have patience with this newbie. I've
got a list layout with data on individuals. When I enter the data in
the layout the summary pulls from for the first individual it shows up
fine in the summary layout. When I enter data for the second
individual, it doesn't show up, in any view in the summary layout.
Doing a find on the account number associated with the individual and
on the individual's name, I still get nothing. Does anyone have any
idea what I'm not doing or what I'm doing wrong?

Also, can anyone point me to a good tutorial on sub-summary and
trailing grand summary set up?

FM Pro Advanced 10

Thanks,
George

--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/

--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/

George R. Hozendorf

Re: Only one entry in summary

Reply Threaded

Thanks, Trish.

I should have used different wording to ask my question, though I do
what the info on summaries. I'll try again.

The layout I'm working on doesn't actually use the sub-summary part.
It's a list format of data pulled from the main layout for each
individual. I.E. Layout one show Bob and Sue both pledged 300 plus
made purchases of 200. The second layout is supposed to show that Sue
completed her pledge and paid for her purchases thus owing nothing.
Bob has only made 2 payments and has only paid for half his purchases
thus owing 200. Right now only Sue is showing up in the 2nd layout in
Preview view. Once I figure out where Bob is, then I'll do my
homework on getting a summary of the total owed by both Bob and Sue.

Hope that's clearer. I'm using FMP 10 Advanced.

George

On Oct 28, 2009, at 10/28/09 - 7:31 AM, VanBuskirk, Patricia wrote:

> Hi George,
>
> I've been working with FMP for about 4 years now, and I still feel
> like
> a newbie most of the time ... there is just so much to know! I have
> always struggled with summaries, for some reason. So anyone else who
> knows better, feel free to correct me here.
>
> Summary fields on a layout (say in the footer) should always show the
> totals for the records found (but can slow things down significantly).
> A summary or grand summary set up in a layout part will only tally
> up in
> preview mode.
>
> I'm not sure what version of FileMaker you are using, but I have FM9A
> and I have 2 books that I reference often for design information:
> "FileMaker Pro 9 Bible" by Ray Cologon and "FileMaker Pro 9 The
> Missing
> Manual" by Geoff Coffey & Susan Prosser. For descriptions and
> examples
> of script steps and commands, etc., I constantly refer to "FileMaker 9
> Developer Reference" by Bob Bowers, Steve Lane and Scott Love. I use
> the heck out of that one! I got all three at Amazon.com.
>
> HTH,
> Trish
>
>
> -----Original Message-----
> From: FileMaker Talk [mailto:[hidden email]] On Behalf Of
> George R. Hozendorf
> Sent: Tuesday, October 27, 2009 10:09 PM
> To: FileMaker Talk
> Subject: Only one entry in summary
>
> OK, I'm baffled again. Please have patience with this newbie. I've
> got a list layout with data on individuals. When I enter the data in
> the layout the summary pulls from for the first individual it shows up
> fine in the summary layout. When I enter data for the second
> individual, it doesn't show up, in any view in the summary layout.
> Doing a find on the account number associated with the individual and
> on the individual's name, I still get nothing. Does anyone have any
> idea what I'm not doing or what I'm doing wrong?
>
> Also, can anyone point me to a good tutorial on sub-summary and
> trailing grand summary set up?
>
> FM Pro Advanced 10
>
> Thanks,
> George
>
> --
> This list is a free service of LassoSoft: http://www.LassoSoft.com/
> Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
> Manage your subscription: http://www.ListSearch.com/FileMaker/
>
>
>
> --
> This list is a free service of LassoSoft: http://www.LassoSoft.com/
> Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
> Manage your subscription: http://www.ListSearch.com/FileMaker/
>
>

Agi Riley

Re: Only one entry in summary

Reply Threaded

In reply to this post by VanBuskirk, Patricia

George,

You know what might make sense for you? Sign up for O'Reilly Safari
Books online. Then you can collect let's say 10 FileMaker books on
your shelf for a low monthly fee and search through them. I used to
have that and considering getting it, again.

The books Patricia referred you to are all really good; I've used them
all.

Also, fmforums.com has most of the questions answered that you can
come up with, because if we have questions, chances are someone has
already asked them.

I've been developing since 1993, still, I have gray areas. :-)

Best,
Agi

Agnes Riley
Sent from my iPhone

On Oct 28, 2009, at 8:31 AM, "VanBuskirk, Patricia" <[hidden email]
> wrote:

Steve Cassidy

Re: Only one entry in summary

Reply Threaded

In reply to this post by George R. Hozendorf

George

You may need to do some rewiring. Either in your Filemaker thinking or
in the database, or perhaps both.

You cannot 'pull' data from a layout. Data resides in fields which are
defined within tables. So you might say that you pull data from a
table, but not from a layout. In fact, although layouts do in a way
'pull' data from tables, the layout really doesn't have much to do
with how you manipulate your data; it is really only a way of
displaying the data.

Do you have a table for 'pledgers' and another for 'pledges/
purchases'? You probably should have. Anyway, you really need to tell
us something about your data structure before anyone can give a
sensible answer to your question.

One way to do what you want is a field that simply sums (via a
relationship to pledges/purchases) the total amount in each pledger
record. With this field on a layout displaying pledgers as a list,
you'll see the balance for each pledger.

In its simplest form, such an arrangement will show the balance over
all history (might be slow). But it would be a good start.

On Oct 28, 2009, at 1:01 PM, George R. Hozendorf wrote:

> Thanks, Trish.
>
> I should have used different wording to ask my question, though I do
> what the info on summaries. I'll try again.
>
> The layout I'm working on doesn't actually use the sub-summary
> part. It's a list format of data pulled from the main layout for
> each individual. I.E. Layout one show Bob and Sue both pledged 300
> plus made purchases of 200. The second layout is supposed to show
> that Sue completed her pledge and paid for her purchases thus owing
> nothing. Bob has only made 2 payments and has only paid for half
> his purchases thus owing 200. Right now only Sue is showing up in
> the 2nd layout in Preview view. Once I figure out where Bob is,
> then I'll do my homework on getting a summary of the total owed by
> both Bob and Sue.
>
> Hope that's clearer. I'm using FMP 10 Advanced.
>
> George

Agi Riley

Re: Only one entry in summary

Reply Threaded

I'm sorry, but I don't agree that pledgers and purchasers need to be
separated out. They are a people with names, addresses and phone
numbers. What you need is either an identifying text field to show you
which group they are in (with checkboxes) and perhaps a flag number
field that marks whether they owe you money or not. You can nicely
script this. Now, the payments and pledges should be in a different
table and each individual one should be a separate record.

I highly recommend using some sort of graph modelling software (or pen
and paper) and draw out your table connections. By the time you're
done you will hopefully have a better idea of figuring out where
things should go.

Also, when you send an email to the list you might want to refresh
people's memory as to what your DB is there to achieve. Let's say you
have a family library with 2 tables: the books and the people. I want
to see how many books each person has and when they borrowed them.
Then get into the technical issue. It makes it easier for all of us.

Hope this helps. :-)

Agi

Agnes Riley
Sent from my iPhone

On Oct 28, 2009, at 10:19 AM, Steve Cassidy
<[hidden email]> wrote:

> George
>
> You may need to do some rewiring. Either in your Filemaker thinking
> or in the database, or perhaps both.
>
> You cannot 'pull' data from a layout. Data resides in fields which
> are defined within tables. So you might say that you pull data from
> a table, but not from a layout. In fact, although layouts do in a
> way 'pull' data from tables, the layout really doesn't have much to
> do with how you manipulate your data; it is really only a way of
> displaying the data.
>
> Do you have a table for 'pledgers' and another for 'pledges/
> purchases'? You probably should have. Anyway, you really need to
> tell us something about your data structure before anyone can give a
> sensible answer to your question.
>
> One way to do what you want is a field that simply sums (via a
> relationship to pledges/purchases) the total amount in each pledger
> record. With this field on a layout displaying pledgers as a list,
> you'll see the balance for each pledger.
>
> In its simplest form, such an arrangement will show the balance over
> all history (might be slow). But it would be a good start.
>
>
> On Oct 28, 2009, at 1:01 PM, George R. Hozendorf wrote:
>
>> Thanks, Trish.
>>
>> I should have used different wording to ask my question, though I
>> do what the info on summaries. I'll try again.
>>
>> The layout I'm working on doesn't actually use the sub-summary
>> part. It's a list format of data pulled from the main layout for
>> each individual. I.E. Layout one show Bob and Sue both pledged
>> 300 plus made purchases of 200. The second layout is supposed to
>> show that Sue completed her pledge and paid for her purchases thus
>> owing nothing. Bob has only made 2 payments and has only paid for
>> half his purchases thus owing 200. Right now only Sue is showing
>> up in the 2nd layout in Preview view. Once I figure out where Bob
>> is, then I'll do my homework on getting a summary of the total owed
>> by both Bob and Sue.
>>
>> Hope that's clearer. I'm using FMP 10 Advanced.
>>
>> George
>
>
> --
> This list is a free service of LassoSoft: http://www.LassoSoft.com/
> Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
> Manage your subscription: http://www.ListSearch.com/FileMaker/
>
>

Steve Cassidy

Re: Only one entry in summary

Reply Threaded

Hi Agi

I didn't say pledgers and purchasers need to be separated out. I
completely agree with you; both are persons, but perhaps with
different attributes.

I said pledgers should be separated from pledges/purchases (note the
lack of an 'r' here!). Pledges/purchases appear to be amounts of money.

Persons and amounts of money are not the same kind of thing at all.
They should likely be separate entities -- especially if, as in this
case, there is a need to sum pledges by pledger.

I didn't want to get too complex in my response, but in fact of course
there's likely a need for a third entity -- 'payments against pledges'
or something along those lines.

Maybe that iPhone screen is a bit small for this kind of thing? Or
perhaps your eyes are fading, as mine are with age!

Steve

On Oct 28, 2009, at 2:37 PM, Agi Riley wrote:

> I'm sorry, but I don't agree that pledgers and purchasers need to be
> separated out.

--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/

Agi Riley

Re: Only one entry in summary

Reply Threaded

Sorry, perhaps both. :-) I totally missed the 'r'. I apologize. I
actually was wondering why you'd say that since you know what you're
talking about.

I just didn't want George to get confused.

"My bad... Said the hedgehog and got off the shoebrush." Good old
Hungarian saying... Hope it's clear. :-)

Agnes Riley
Sent from my iPhone

On Oct 28, 2009, at 11:23 AM, Steve Cassidy
<[hidden email]> wrote:

> Hi Agi
>
> I didn't say pledgers and purchasers need to be separated out. I
> completely agree with you; both are persons, but perhaps with
> different attributes.
>
> I said pledgers should be separated from pledges/purchases (note the
> lack of an 'r' here!). Pledges/purchases appear to be amounts of
> money.
>
> Persons and amounts of money are not the same kind of thing at all.
> They should likely be separate entities -- especially if, as in this
> case, there is a need to sum pledges by pledger.
>
> I didn't want to get too complex in my response, but in fact of
> course there's likely a need for a third entity -- 'payments against
> pledges' or something along those lines.
>
> Maybe that iPhone screen is a bit small for this kind of thing? Or
> perhaps your eyes are fading, as mine are with age!
>
> Steve
>
> On Oct 28, 2009, at 2:37 PM, Agi Riley wrote:
>
>> I'm sorry, but I don't agree that pledgers and purchasers need to
>> be separated out.
>
>
> --
> This list is a free service of LassoSoft: http://www.LassoSoft.com/
> Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
> Manage your subscription: http://www.ListSearch.com/FileMaker/
>
>

George R. Hozendorf

Re: Only one entry in summary

Reply Threaded

In reply to this post by Steve Cassidy

This has gotten way too complicated due to my not explaining what I
was asking at first concisely. The layout only shows one pledger/
puchaser. Not all. It makes no difference which view I'm in. Why am
I only getting one person, not the 20+ I should be seeing? There is
no connection between the pledge/purchaser, so all should be showing
up on the list.

FMPro 10 Advanced
George

On Oct 28, 2009, at 10/28/09 - 9:19 AM, Steve Cassidy wrote:

Serge Schongut

Re: Only one entry in summary

Reply Threaded

In reply to this post by George R. Hozendorf

Hi George,
This will happen if
Either Your Layout is not set in ListView or Your found set contains only 1
record.
Please check the Layout setup to be in List View and Find all records.
This should clear Yr immediate problem: further improvement will most
probably require
additional reading in order to redefine the data structure.
Hoping this helps,

Serge Schongut
Elico Belgium

***Even dwarfs were born small***

----- Original Message -----
From: "George R. Hozendorf" <[hidden email]>
To: "FileMaker Talk" <[hidden email]>
Sent: Wednesday, October 28, 2009 5:40 PM
Subject: Re: Only one entry in summary

> This has gotten way too complicated due to my not explaining what I was
> asking at first concisely. The layout only shows one pledger/ puchaser.
> Not all. It makes no difference which view I'm in. Why am I only
> getting one person, not the 20+ I should be seeing? There is no
> connection between the pledge/purchaser, so all should be showing up on
> the list.
>
> FMPro 10 Advanced
> George
>
>
> On Oct 28, 2009, at 10/28/09 - 9:19 AM, Steve Cassidy wrote:
>
>> George
>>
>> You may need to do some rewiring. Either in your Filemaker thinking or
>> in the database, or perhaps both.
>>
>> You cannot 'pull' data from a layout. Data resides in fields which are
>> defined within tables. So you might say that you pull data from a table,
>> but not from a layout. In fact, although layouts do in a way 'pull' data
>> from tables, the layout really doesn't have much to do with how you
>> manipulate your data; it is really only a way of displaying the data.
>>
>> Do you have a table for 'pledgers' and another for 'pledges/ purchases'?
>> You probably should have. Anyway, you really need to tell us something
>> about your data structure before anyone can give a sensible answer to
>> your question.
>>
>> One way to do what you want is a field that simply sums (via a
>> relationship to pledges/purchases) the total amount in each pledger
>> record. With this field on a layout displaying pledgers as a list,
>> you'll see the balance for each pledger.
>>
>> In its simplest form, such an arrangement will show the balance over all
>> history (might be slow). But it would be a good start.
>>
>>
>> On Oct 28, 2009, at 1:01 PM, George R. Hozendorf wrote:
>>
>>> Thanks, Trish.
>>>
>>> I should have used different wording to ask my question, though I do
>>> what the info on summaries. I'll try again.
>>>
>>> The layout I'm working on doesn't actually use the sub-summary part.
>>> It's a list format of data pulled from the main layout for each
>>> individual. I.E. Layout one show Bob and Sue both pledged 300 plus
>>> made purchases of 200. The second layout is supposed to show that Sue
>>> completed her pledge and paid for her purchases thus owing nothing.
>>> Bob has only made 2 payments and has only paid for half his purchases
>>> thus owing 200. Right now only Sue is showing up in the 2nd layout in
>>> Preview view. Once I figure out where Bob is, then I'll do my homework
>>> on getting a summary of the total owed by both Bob and Sue.
>>>
>>> Hope that's clearer. I'm using FMP 10 Advanced.
>>>
>>> George
>>
>>
>> --
>> This list is a free service of LassoSoft: http://www.LassoSoft.com/
>> Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
>> Manage your subscription: http://www.ListSearch.com/FileMaker/
>>
>>
>
>
> --
> This list is a free service of LassoSoft: http://www.LassoSoft.com/
> Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
> Manage your subscription: http://www.ListSearch.com/FileMaker/
>
>

VanBuskirk, Patricia

Re: Only one entry in summary

Reply Threaded

It can also happen if ield(s) on the layout fall outside of the
parameters of the part, ie. overlaps into the header or footer.

-----Original Message-----
From: FileMaker Talk [mailto:[hidden email]] On Behalf Of
Serge Schongut
Sent: Wednesday, October 28, 2009 1:12 PM
To: FileMaker Talk
Subject: Re: Only one entry in summary

Hi George,
This will happen if
Either Your Layout is not set in ListView or Your found set contains
only 1
record.
Please check the Layout setup to be in List View and Find all records.
This should clear Yr immediate problem: further improvement will most
probably require
additional reading in order to redefine the data structure.
Hoping this helps,

Serge Schongut
Elico Belgium

***Even dwarfs were born small***

----- Original Message -----
From: "George R. Hozendorf" <[hidden email]>
To: "FileMaker Talk" <[hidden email]>
Sent: Wednesday, October 28, 2009 5:40 PM
Subject: Re: Only one entry in summary

> This has gotten way too complicated due to my not explaining what I
was
> asking at first concisely. The layout only shows one pledger/
puchaser.
> Not all. It makes no difference which view I'm in. Why am I only
> getting one person, not the 20+ I should be seeing? There is no
> connection between the pledge/purchaser, so all should be showing up
on

> the list.
>
> FMPro 10 Advanced
> George
>
>
> On Oct 28, 2009, at 10/28/09 - 9:19 AM, Steve Cassidy wrote:
>
>> George
>>
>> You may need to do some rewiring. Either in your Filemaker thinking

or
>> in the database, or perhaps both.
>>
>> You cannot 'pull' data from a layout. Data resides in fields which
are
>> defined within tables. So you might say that you pull data from a
table,
>> but not from a layout. In fact, although layouts do in a way 'pull'
data
>> from tables, the layout really doesn't have much to do with how you
>> manipulate your data; it is really only a way of displaying the
data.
>>
>> Do you have a table for 'pledgers' and another for 'pledges/
purchases'?
>> You probably should have. Anyway, you really need to tell us
something
>> about your data structure before anyone can give a sensible answer
to
>> your question.
>>
>> One way to do what you want is a field that simply sums (via a
>> relationship to pledges/purchases) the total amount in each pledger
>> record. With this field on a layout displaying pledgers as a list,
>> you'll see the balance for each pledger.
>>
>> In its simplest form, such an arrangement will show the balance over
all
>> history (might be slow). But it would be a good start.
>>
>>
>> On Oct 28, 2009, at 1:01 PM, George R. Hozendorf wrote:
>>
>>> Thanks, Trish.
>>>
>>> I should have used different wording to ask my question, though I
do
>>> what the info on summaries. I'll try again.
>>>
>>> The layout I'm working on doesn't actually use the sub-summary
part.
>>> It's a list format of data pulled from the main layout for each
>>> individual. I.E. Layout one show Bob and Sue both pledged 300
plus
>>> made purchases of 200. The second layout is supposed to show that
Sue
>>> completed her pledge and paid for her purchases thus owing nothing.

>>> Bob has only made 2 payments and has only paid for half his
purchases
>>> thus owing 200. Right now only Sue is showing up in the 2nd layout
in
>>> Preview view. Once I figure out where Bob is, then I'll do my
homework

>>> on getting a summary of the total owed by both Bob and Sue.
>>>
>>> Hope that's clearer. I'm using FMP 10 Advanced.
>>>
>>> George
>>
>>
>> --
>> This list is a free service of LassoSoft: http://www.LassoSoft.com/
>> Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
>> Manage your subscription: http://www.ListSearch.com/FileMaker/
>>
>>
>
>
> --
> This list is a free service of LassoSoft: http://www.LassoSoft.com/
> Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
> Manage your subscription: http://www.ListSearch.com/FileMaker/
>
>

VanBuskirk, Patricia

Re: Only one entry in summary

Reply Threaded

Of course ield(s)=field(s)

-----Original Message-----
From: FileMaker Talk [mailto:[hidden email]] On Behalf Of
VanBuskirk, Patricia
Sent: Wednesday, October 28, 2009 1:16 PM
To: FileMaker Talk
Subject: Re: Only one entry in summary

It can also happen if ield(s) on the layout fall outside of the
parameters of the part, ie. overlaps into the header or footer.

-----Original Message-----
From: FileMaker Talk [mailto:[hidden email]] On Behalf Of
Serge Schongut
Sent: Wednesday, October 28, 2009 1:12 PM
To: FileMaker Talk
Subject: Re: Only one entry in summary

Hi George,
This will happen if
Either Your Layout is not set in ListView or Your found set contains
only 1
record.
Please check the Layout setup to be in List View and Find all records.
This should clear Yr immediate problem: further improvement will most
probably require
additional reading in order to redefine the data structure.
Hoping this helps,

Serge Schongut
Elico Belgium

***Even dwarfs were born small***

----- Original Message -----
From: "George R. Hozendorf" <[hidden email]>
To: "FileMaker Talk" <[hidden email]>
Sent: Wednesday, October 28, 2009 5:40 PM
Subject: Re: Only one entry in summary

> This has gotten way too complicated due to my not explaining what I
was
> asking at first concisely. The layout only shows one pledger/
puchaser.
> Not all. It makes no difference which view I'm in. Why am I only
> getting one person, not the 20+ I should be seeing? There is no
> connection between the pledge/purchaser, so all should be showing up
on

> the list.
>
> FMPro 10 Advanced
> George
>
>
> On Oct 28, 2009, at 10/28/09 - 9:19 AM, Steve Cassidy wrote:
>
>> George
>>
>> You may need to do some rewiring. Either in your Filemaker thinking

--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/

--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/

--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/

Steve Cassidy

Re: Only one entry in summary

Reply Threaded

In reply to this post by George R. Hozendorf

On Oct 28, 2009, at 4:40 PM, George R. Hozendorf wrote:

> This has gotten way too complicated due to my not explaining what I
> was asking at first concisely. The layout only shows one pledger/
> puchaser. Not all. It makes no difference which view I'm in. Why
> am I only getting one person, not the 20+ I should be seeing? There
> is no connection between the pledge/purchaser, so all should be
> showing up on the list.

George

I don't think it is a question of conciseness. But anyway...

Your original post talked of summaries, summary layouts, and summaries
pulling from layouts. Unfortunately, this is not really Filemaker
terminology. It may be that we've picked up on certain elements of
what you wrote -- particularly the word summary, which has a few
particular meanings within Filemaker -- and assumed a complexity that
you don't have.

It may be that Serge has it right: you have a layout in list view but
for some reason it is not showing more than one record.

What does your status area show? There you should be able to see if
you are on the right track. It will tell you how many records are in
the table and how many are in the found set (ie displayed currently in
browse view). If these numbers are not equal, then you need to do Find
All to see all your records.

If the total number of records is 1, then you have a problem with what
table the layout is based on; it may be set to a different table from
the one where you originally entered the data.

On the other hand, you were asking about summary and sub-summary parts
earlier in the thread. If those are involved, then all bets are off;
the situation is going to be more complex.

Hope that helps a little. If it doesn't and you remain frustrated with
the problem, I suggest you write back to us detailing the table(s) in
your database file, the layouts (and which tables they are based on),
and some idea of what records are present in the table(s).

Steve

--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/

Agi Riley

Re: Only one entry in summary

Reply Threaded

In reply to this post by George R. Hozendorf

George, send me a screenshot of your layout in layout view and your
ERD off list.

Agnes B. Riley
[hidden email]

Member, FileMaker Business Alliance
Member, FileMaker Technical Network

FileMaker 10 on Mac OS X 10.5.7

"Imagination is more important than knowledge..."
/Albert Einstein/

On Oct 28, 2009, at 12:40 PM, George R. Hozendorf wrote:

> This has gotten way too complicated due to my not explaining what I
> was asking at first concisely. The layout only shows one pledger/
> puchaser. Not all. It makes no difference which view I'm in. Why
> am I only getting one person, not the 20+ I should be seeing? There
> is no connection between the pledge/purchaser, so all should be
> showing up on the list.
>
> FMPro 10 Advanced
> George
>
>
> On Oct 28, 2009, at 10/28/09 - 9:19 AM, Steve Cassidy wrote:
>
>> George
>>
>> You may need to do some rewiring. Either in your Filemaker thinking
>> or in the database, or perhaps both.
>>
>> You cannot 'pull' data from a layout. Data resides in fields which
>> are defined within tables. So you might say that you pull data from
>> a table, but not from a layout. In fact, although layouts do in a
>> way 'pull' data from tables, the layout really doesn't have much to
>> do with how you manipulate your data; it is really only a way of
>> displaying the data.
>>
>> Do you have a table for 'pledgers' and another for 'pledges/
>> purchases'? You probably should have. Anyway, you really need to
>> tell us something about your data structure before anyone can give
>> a sensible answer to your question.
>>
>> One way to do what you want is a field that simply sums (via a
>> relationship to pledges/purchases) the total amount in each pledger
>> record. With this field on a layout displaying pledgers as a list,
>> you'll see the balance for each pledger.
>>
>> In its simplest form, such an arrangement will show the balance
>> over all history (might be slow). But it would be a good start.
>>
>>
>> On Oct 28, 2009, at 1:01 PM, George R. Hozendorf wrote:
>>
>>> Thanks, Trish.
>>>
>>> I should have used different wording to ask my question, though I
>>> do what the info on summaries. I'll try again.
>>>
>>> The layout I'm working on doesn't actually use the sub-summary
>>> part. It's a list format of data pulled from the main layout for
>>> each individual. I.E. Layout one show Bob and Sue both pledged
>>> 300 plus made purchases of 200. The second layout is supposed to
>>> show that Sue completed her pledge and paid for her purchases thus
>>> owing nothing. Bob has only made 2 payments and has only paid for
>>> half his purchases thus owing 200. Right now only Sue is showing
>>> up in the 2nd layout in Preview view. Once I figure out where Bob
>>> is, then I'll do my homework on getting a summary of the total
>>> owed by both Bob and Sue.
>>>
>>> Hope that's clearer. I'm using FMP 10 Advanced.
>>>
>>> George
>>
>>
>> --
>> This list is a free service of LassoSoft: http://www.LassoSoft.com/
>> Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
>> Manage your subscription: http://www.ListSearch.com/FileMaker/
>>
>>
>
>
> --
> This list is a free service of LassoSoft: http://www.LassoSoft.com/
> Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
> Manage your subscription: http://www.ListSearch.com/FileMaker/
>
>

Michael Gilman

Re: Only one entry in summary

Reply Threaded

In reply to this post by George R. Hozendorf

George,

Sometimes its best just to give the an example (screenshot) of what you are
talking about. This list serve has a lot of great developers and tons of
information to provide, yet when something becomes elusive... well you all
know what I am talking about.
Show a couple of screen shots and I think then you will get a better
solution response to what you are looking to achieve.

Michael Gilman

-----Original Message-----
From: FileMaker Talk [mailto:[hidden email]] On Behalf Of George
R. Hozendorf
Sent: Wednesday, October 28, 2009 12:41 PM
To: FileMaker Talk
Subject: Re: Only one entry in summary

This has gotten way too complicated due to my not explaining what I
was asking at first concisely. The layout only shows one pledger/
puchaser. Not all. It makes no difference which view I'm in. Why am
I only getting one person, not the 20+ I should be seeing? There is
no connection between the pledge/purchaser, so all should be showing
up on the list.

FMPro 10 Advanced
George

On Oct 28, 2009, at 10/28/09 - 9:19 AM, Steve Cassidy wrote: