Andy_

Hello, Does anyone have any experience of a script that sometimes works then stops working at random times? I have a script which runs through a few fields duplicating some data and inserting the text 'updated' into another field so the users know it all works. Thing is, sometimes the script stops working for no apparent reason. Opening and closing the script in scriptmaker. Or reselecting it in perform external script also seems to 'wake it up'. Does anyone have any idea what could be causing this? I should also point out that it happens on PC and Mac clients. Thanks for any help.

Thanks for the advice. Unfortunately I don't have Bowers and Moyer "Advanced FileMaker" book ! I am also unsure about "loop and pipe characters". Any other help ?

Hi, I have a sales file with fields for company, month, year, invoice number, total items sold, price and invoice total. The further details of each sale are stored in a separate sales details file. I want to make a page or layout where I can compare sales in a grid of month and year but so far have been unable to do this. I was thinking a grid of calculation fields might do this but not sure how to make a field only show the total items sold in Jan 2003 or March 2004 for example. Can I somehow use 'finds' within calculation fields? Does anyone have any suggestions for how I could do this? Andy

I have a sales report in preview mode. I have a summary field showing sub-totals, I would like the report sorted by this field so that the higher sales figures sit at the top of the report. When I look at my report in preview mode it is sorted by product, I have to click 'sort' then the checkbox to include summary fields, then move the summary sub total field into the right hand field list, then click 'descending order', then click 'sort'. Question is - How can I automate this? Surely it must be possible Thanks for any help

Thanks guys, that was really helpful. One more question though if I may... Is there any clever way to sort by subtotal of quantity so that the highest selling products appear at the top of the report? Because of the grouped data it seems to have to sort by product name.

I have a relational database containing reseller details, sales records, stock levels etc. I'm quite happy with the way it's working, however, I have run into some problems as I try to create some meaningful reports to run. I have a 'sales details' database containing all of my sales information. I want a sales report that can show me the total sales for all my products, by month or year or region or whatever. The issue I have is as follows. When I find all of my sales, say for a particular month, I get something that looks like this as I have different resellers making sales of the same product in the same month. Item ----- Quantity ProductA ----- 1 ProductA ----- 1 ProductA ----- 3 ProductB ----- 1 ProductB ----- 7 PrdocutC ----- 1 ProductE ----- 1 ProductE ----- 4 Can anybody suggest a useful way to generate a report which would total these for me? I do have a separate file for stock items I could run some script against but I haven't been able to think of a way to make it work. Any help would be appreciated.

I am trying to make a relational database. I basically have the Following, one table for reseller info, one for sales records and another one for stock levels. The whole thing is working quite well, I can see how much of a particular product each reseller has because I have a table with a key of resellerID_productID' to which I can have a stock value and know when I need to restock. I have over 200 products and over 100 resellers so my stock by reseller table is quite long. I need some help with a script to make it that when I add a new reseller, my 'stock by reseller' table writes new lines of 'newResellerID_productID' for however many products I have. Similarly when I add new products I need a script to add 'resellerID_newProductID' for however many resellers I have. i.e. KEY ---------------------------STOCK LEVEL resellerA_productA --------------- 5 resellerA_productB --------------- 5 resellerA_productC --------------- 5 resellerB_productA --------------- 5 resellerB_productB --------------- 5 resellerB_productC --------------- 5 resellerC_productA --------------- 5 resellerC_productB --------------- 5 resellerC_productC --------------- 5 button to add new product should change this table to... KEY ---------------------------STOCK LEVEL resellerA_productA--------------- 5 resellerA_productB--------------- 5 resellerA_productC--------------- 5 resellerA_productD--------------- 0 resellerB_productA--------------- 5 resellerB_productB--------------- 5 resellerB_productC--------------- 5 resellerB_productD--------------- 0 resellerC_productA--------------- 5 resellerC_productB--------------- 5 resellerC_productC--------------- 5 resellerC_productD--------------- 0 Is there an easy way to do this? I would be grateful if anyone could help with this as I can't seem to find the answer. Andy

Thank you very much Echo, this is perfect. Andy

Hello, I am trying to have a price looked up and automatically filled in to a sales record in a portal. I have attached a graphic of a simplified version of what I want to do to help explain. I basically have four tables, a list of products, a price chart, a client page and one to record all sales. When inputting a sales record I want the price to be looked up after selecting the appropriate currency and product name from pull down menus but I have so far been unable to get this to work. I would be very grateful if anyone could provide any example script or suggestions as to how to do this as it has been giving me a headache for some time now. I am also not sure how to combine my table of products with the column headings in the price chart and the drop down menu in the portal. Thanks in advance for any help ! Andy