Ben Ball Posted February 23, 2006 Posted February 23, 2006 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 Posted February 23, 2006 Posted February 23, 2006 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 Posted February 24, 2006 Posted February 24, 2006 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 Posted February 25, 2006 Posted February 25, 2006 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 Posted February 25, 2006 Posted February 25, 2006 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 Posted February 26, 2006 Author Posted February 26, 2006 (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 February 26, 2006 by Guest
Søren Dyhr Posted February 26, 2006 Posted February 26, 2006 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 Posted February 27, 2006 Author Posted February 27, 2006 SØren, Thanks for the explanation, I am sure I'll have fun trying to workit all out! Ben
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now