ScottR

EOS - thanks for the quick reply. Sorry for the double hit (The forum was an afterthought). Let me look at what you've created. I have a feeling you've nailed it again. Thanks.

I've got to believe I'm just having a brief episode of "stupid" and I'm just over thinking this... I'm essentially trying to create a portal of summaries of items that appear in another portal. Here's the plan... I have a table with individual expense items. I then I have table used for invoicing the expensed items. The data is sorted by date and customer and category creating an invoice with the total amounts. There are several items on each invoice of the same category (i.e. meals & entertainment, or car rental or hotel). A simplified list of expenses on the invoice might look like this.. 04/01/14 Hotel $250 04/20/14 Car $63 04/02/14 Meals $50 04/03/14 Hotel $200 04/12/14 Meals $50 04/06/14 Hotel $175 04/16/14 Meals $48 I'm trying to create a portal that lists the summaries of the categories. Something like this... Hotels $625 Meals $148 Car $63 Since the categories are dynamic, and I'm filtering by invoice number I can't set up summary fields for each category. I've created a self-join relationship and used the GetNthRecord trick to grab the first occurrence of each category from the main portal but now trying to grab the totals of each category is presenting a problem. If I simply do a GetSummary of each category it only lists the amount of the first record (due to the GetNthRecord used in the portal filter). I'm looking forward to learning the errors of my ways! Thanks.

The first challenge in finding the answer to a Filemaker question is trying to figure out how to ask the question! Here goes… I have two data files, one is a host on FM11 being accessed remotely by the client file residing on other machines including FMGo. I have records in the host file that contain fields that contain auto-enter lookup values from a related field in the client file. (The purpose of this is to create duplicate records that have been created by clients). I must say, it all works great. With one problem. The FIRST time the client creates a new record in the host file and inserts a value into the related field, the host database can't find the client to lookup the value. After selecting the location of the client, it finds it and works great. Any new records created after that will work just fine as the host now knows the location of the client apparently. So my question is this, is there some way to tell a remotely accessed host database the location of the client that it has the relationship with in a script so that the user doesn't have to manually tell the host where the client is the first time? I understand how to manage external data sources with known locations, but you never really know where the client will be therefore I need a way to tell the host without the user being interrupted with the dialog box, "The file <filenamehere> could not be opened. (not found)" the first time its accessed. I hope thats clear! :-) Thanks.