Daveyoneusa

First of all, thanks for the advice I received in my last couple of posts. It has helped a great deal. I reworked the Event Management starter and have everything working and printing great. Added expenses and invoices and a bunch of other features. Here's my last little tweak. Not a necessity, but useful. All of the existing Event Management tables and relationships are intact There is a portal on the Event Details layout that contains contributors for the event. There is a button for emailing all the contributors. I would like it to only email to the contributor who has "Invoice" entered into the Role field of the contributors portal. So I need to do some sort of find in the portal for the contributor with the role of "Invoice. There is also a little button next to the contributors name for emailing, but I would like to attach different files to the email for different people. I can get the script to attach the file and start up the email program, but it attaches the email of the person in the active row of the portal. How do0 I get the script to look into the portal and choose the email from a specific person? Thanks for all your help! Dave

Hi, thanks in advance for your help. I have learned a great deal on this site.  I have a table of Events. Linked to that table is a table of Expenses. The Expenses portal is inside a tabbed area and works well showing the expenses associated with each event. One of the tabbed portals EXPENSES is filtered to only show expense values above zero so it shows only expenses. The other tab, BALANCE, shows all the expenses and and payments related to the event. If everything has been paid, the total charges are zero  I have a one line portal with a summary field REPORT ANOUNT TOTAL (It's labeled as Expenses that totals the expenses in the filtered or unfiltered portal. I have a field below that field that calculates the event charges per day. SUB_DAY_CHARGES  (It's labeled as Retreat Fee) I have a field below that portal the calculates the # of guest rooms and charges for the rooms. SUB_ROOM_CHARGES (It's labeled as Room CHarges)  I have another one line portal under that that calculates all of the above fields.. TOTAL_CHARGES (It's labeled as total charges)  As long as there are records in the expenses portal, the whole thing works great. If there are no records in the portal for expenses then neither of the one line portals calculates. AS soon as one record shows up on the portal everything is fine. There may be an instance where there are no expenses and only fees so I would like this to be able to work without portal records if necessary.  I tried this for my total_charges field and it didn't make a difference;  If (IsEmpty ( Report Amount Total ) ; Events::sub_day_charges + Events::sub_room_charges ; Report Amount Total + Events::sub_day_charges + Events::sub_room_charges )   Oops, sent the wrong picture. This was before I corrected the calculations. It does accurately calculated with records. but not without.

Thanks! I have been trying without success. It seems like the tables are set up the same way for both guests and contributors so I'm having trouble seeing why I can't get it to work. I'll keep trying... Thanks for your advice! Dave

Hi, thanks for any help you can provide. Long-time FM user, but it's been a while since I did any database development. Just upgraded to FM12 Advance from FM 4.0! Set up a database back then and have been using it ever since. Â I like the Event Management Starter Solution as a base for tracking diners and retreats we host at work. But we don't have any Contributors, we only have Guests. I would like to set up a Contacts Details layout that is exactly the same as the one provided in the Event Management solution with one change. I would like the portal on the bottom of the layout to reflect the Events that the Contact has been a Guest at, rather than a Contributor to. I just can seem to get the Guest relationship right. Â Thanks for any advice! Â Dave