DavidEman

Thanks for the response. That make sense. Basically what I am trying to do is this: Let's say I have an Invoice table with fields: Customer Invoice Amount Payment I summarize all Invoice Amounts and all Payments, grouped by Customer and then calc a balance by subtracting the Summary Payment from Summary Invoice Amount. On the report I want to exclude all Customers with a zero balance. I can not create a Balance (calc) field because I am importing the information from somewhere else and Invoice Amount and Payment are not in the same record. They are in different records, no one record has an Invoice Amount and a Payment. I can sort of accomplish what I want by creating a Customer record in a separate database, but I am trying to avoid this. I hope that makes sense. Thanks again for your help. David

I think this is a pretty basic question, but I just can't seem to figure it out. I am generating a report which has two summary fields - Addition (totaling numbers), Subtraction (totaling numbers) and a calcuation field Balance (Addition - Subtraction). I want the report to only show amounts wher Balance is greater than zero. I can't do a find on the summary field to exclude records, so how can I accomplish this. Thanks so much for your help. David

Yeh, I'm not too happy with the setup, but they want a secure server. The DB isn't shared, only used by one person. We are using FMP 9 Advanced - latest update, I think. In a script, I am setting a variable to 'file:../Desktop/FileName.txt' Is that my problem?

If I understand you correctly, you'll need to use a new table MemberQuantity to contain Customer, Product and Quantity. Then set the Relationship from Lines to MemberQuantity to be based on Customer and Product. Have Quanity in Lines lookup from MembeQuantity. You could have Customer lookup from Invoice, so you won't have to populate it. Then when you select the Product it will pull Quantity from MemberQuanity. Note that when you have a few lookups the timing can get funky, so you may need to put a script in to get the timing right. What I mean is that the portal row needs to be committed with the Customer before it will lookup the Quantity.

I've got a solution setup where the database is residing on a shared drive (for security reasons) and the database is being opened single user. I have a script run that automatically exports records to a text file on the user's desktop. I get a write error when it tries to run the export (not enough room on the drive, change the name, etc.). When I move the database to the C: drive, it exports fine. We are running Windows XP. Anyone have any idea how to get this to work without moving the file to the c: drive? Thanks for your help.

Hey Toko, What I've done in the past is put the values as records in another table, then show those records as a portal and put the script on the field in the portal. For example, I'll have a list of employees in another table. Adding another employee just adds another row in the portal. Hope that helps.

I've got a site running using IWP. Basically when a user logs in, a record is marked as 'Open'. When they finish the record it is marked as 'Closed'. I've got Cancel buttons throughout that 'Closes' a record. I'm trying to find a way to 'Close' a record for those users who just leave the site without hitting cancel. Anyone have any ideas? I'd like to run a script when a user's session expires automatically, but I don't think that is possible. Thanks for any ideas David

I've developed a website using Instant Web Publishing, but wish to link to a specific record in the database from an external html page and display it using IWP. I know I can do it by running a startup script and using the Get (AccountName) function, but that doesn't really work for me. What I'm hoping to do, is create a CWP query and pass that to my IWP solution. Is that possible? If so, could someone construct the query for me, I'm not very familar with CWP. Thanks so much for your help.

Please bare with me, I am new to XML and have a basic question. I've got a networked solution where we export to XML using an XSL stylesheet that is located in a specific folder (inside the FMP Application folder) on each person's computer. How do I name the path to the stylesheet, so if we add a new computer it can have any name or someone changes the name of their computer and still find the stylesheet? Thanks for your assistance

I've got FMP server 5 running about 10 databases. I'm trying to backup a single database to a specific location. When I set the backup schedule and try to choose just one database, the databases are greyed out. Using FMP schedules, can I only backup folders or all of the databases? I'd prefer not to separate the databases into separate folders. I'm not too good at AppleScript, so if that is my only choice, does anyone have a sample script that I could look at? Thanks for your help.

I don't think it will work using the date of the last task in the master record because they'll need to go in a change the dates later on. I was thinking about somehow setting up a relationship in the Tasks DB to the previous record, but I couldn't get it to work. Tasks shouldn't run parallel because each task needs the previous one to finish before it can start.

I'm having a bit of a problem setting up database with dynamically calculating dates. Please bear with me while I try to explain my problem. I've got a Master file handling Job Information. This record will contain a Promise Date. I want to setup a portal where someone can create multiple unlimited Tasks for the Job and assign a length of time for that Task. That Task will then calculate a Start Date for that task by subtracting from the Promise Date. As a new Task is created it needs to calculate from the previous Task. The idea is to create a timeline report listing all of the Tasks and the days that they need to begin. Of course, as things change, they want to adjust the schedules. I won't go through everything I've tried because it hasn't worked, but I would appreciate any thoughts anyone has on setting this up. Thanks so much for your help.