Portal Viewing or script?

[Ben Ball]

One for discussion maybe?

I have a portal that shows records. Based on Month and year. This is for invoicing.

I need to portal to show me one of each customer that requires invoicing for the particular month.

At the moment I can only get the portal to show all records for each customer, whereas I just need the portal to show one record for each customer, regardless if there are 1 or 10 off.

Is it possible to do this?

I thought about setting a field in my clients table to say "Invoice" when an order is placed on that customer.

Then showing a portal to the clients table which shows clients that have orders against them.

I will then only show one customer that requires invoicing. Obviously then, once printed going through the clients records and setting the Invoiced field to "Nothing". I think this may be long winded??

There must be abetter way??

Ben

[Genx]

Well, to make sure you're getting the right related record, do a sort directly through the relationship in define database. Then go back to your layout and just delete the portal...leaving only your original related fields. This ensures that only the first related record is shown.

~Genx

[Søren Dyhr]

What a relief you're on fm8a on this one, since it makes it much easier, although it should be possible under fm6 as well.

I have chosen a relative simple relational structure, and desided put my eggs in a borrowed CF and borrowed algorithm instead:

The CF from:

http://www.nightwing.com.au/FileMaker/demos8/demo804.html

The algorithm from:

http://www.onegasoft.com/tools/fastsummaries/index.shtml

--sd

sdFindUniq.zip

[comment]

Hmmm.. a custom function AND a script AND version 8 only - have you forgotten about Ugo's method for de-duping a portal?

[Søren Dyhr]

Hmmm.. a custom function AND a script AND version 8 only - have you forgotten about Ugo's method for de-duping a portal?

No - not at all! But thats what I meant with simple relationships ...It's more a question what comes first intuitively - than whats the best approach by and large. Just as some developers feels repeating field comes creaping out of every crack

--sd

[Ben Ball]

SØren,

Thankyou for that, very helpful and opens my eyes even further. I have no experience with "set variable" command. I have been wondering on how to do that with the buttons. Changing whats written that is. Again, filemaker gets more powerfull.

Comment, thanks for showing the link. I believe this option is kind of simpler to implement to my application.

Ben

Edited February 26, 2006 by Guest

[Søren Dyhr]

I have been wondering on how to do that with the buttons. Changing whats written that is.

First off is it not a real button, but instead a embossed calcfield returning numbers in boolean format, the field is then made a button by it's outline.

Other methods exist though; on ordinary buttons can the text be a <> which references a calc'field - which allows for even more choises than the boolean button you saw in the template.

--sd

[Ben Ball]

SØren,

Thanks for the explanation, I am sure I'll have fun trying to workit all out!

Ben