Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 6860 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

Posted

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

Posted

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

Posted

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

Posted (edited)

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 by Guest
Posted

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

Posted

SØren,

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

Ben

This topic is 6860 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.