djmiller

Garry, Create a Calculation (unstored) field called Daily Balance with the formula credit-debit. Create another field called Daily Balance Running. This is a summary field = Total of Daily Balance (running). This will give you the required result.

A customer decides what items they want. From a customer database a new job ticket is created and all of the items this customer wants are entered via a portal. As the items are entered, fields in the portal are populated with information from another database about the item such as price, color, size and category. The category may be wood, metal, plastic, glass, or paper. The order that the items are entered is critical for assembly at a later date. None of the categories are really important except for the paper one. What I need is a (auto entry) counter so that everytime paper is the category a (field named paperpostion) would populate with it's position (starting with 1) and increase by 1 everytime paper was the category. Like this item category paperposition metal wood paper 1 paper 2 plastic glass paper 3 The next customer decides the items they want and if paper is one of them, their first paper item would get a number 1 and so on. A solution that seems so simple eludes me. Any help is greatly appreciated.

I guess I have already figured it out. I created several global fields, one of them a counter. I then ran thru the records and assigned them the counter number and increased it 1 for each record. Then a sort on that number which essentially keeps the records in the initial order. Then do my duplicating and blanking out the counter numbers. Works perfect everytime and doesn't increase the size of my database. Thanks for the help and sorry I posted maybe a little too soon.

I have two databases related to each other by a ticket number. When I create a new job a new ticket number is generated and I enter information into the related portal. It is imperative that the information in the portal retain the order in which it was entered. I have had no problem duplicating the ticket and all the records in the portal provided I don't mind sorting the portal records on a field that messes up the original order. My dilema is duplicating the portal records and maintaing the original entry order. If I sort on the ticket # (filemaker tells me it did sort them although it didn't actually change the order) I only get a duplicate of the first record in my loop. If I sort on any other field (filemaker tells me it did sort them) I do get duplicates for each record but not in the desired order. I know that I can enter say a serial number filed and increment it by 1 on creation and sort by that, but that just makes the database that much larger. Any other ideas?

Well I finally found the answer. Not sure why but I noticed that I had capitalized all of the names of my databases except for the tickets.fp7. Changed it to an uppercase T (which I think Developer 7 was stubborn about) and re-ran the Developers Utility to create my solution. It worked like a charm. I can't believe that this was the error that was making my life hell. Stanley, I should have paid a little more attention to you and your suggestion of where my files were pointing. It was pointing to the tickets db and not the Tickets db. I bow to your superior knowledge. Thanks everyone for your help, and when given choices by filemaker, accept them and don't change anything afterwards.

Thanks Ender, but I only have the databases in the folder.

No second computer and no custom functions or plugin being used. Thanks for the help Stanley, nut I think we are fighting a battle that has no winner. I think I am going to try and rewrite the solution to specifically use just the tickets database then compile to see if I get the same eror messages. Thanks for all your help.

If I didn't already shave my head I'd still be bald for pulling my hair out. I did a recover on the tickets.fp7 file. No errors found. Remade the solution and the same error. If I create all the necessary files for the application and the whole thing works fine prior to using developer to create the solution (as in all files found and everything working OK) doesn't it stand to reason that the solution would work also? And why is it that when I create the solution all files including tickets.fp7 appear in the solutions folder? Stanley, I really appreciate your help with this. Thanks

There are 17 databases in this solution. Tickets is one of them. When I create the run time, developer does its thing. The tickets database as well as the rest of the databases shows up in the newly created folder. I just can't figure out why when I start the run time application it will not find the tickets database without me manually telling it where it is.

I had thought the same thing, but none of the files have ever been moved. Everything is where it should be. And everything points to the correct location. If it runs prior to creating a solution and finds the correct files, shouldn't it find the correct files once I actually create the solution?

I have created a solution that seems to work fine until it calls for a particular database. A message pops up and says that "tickets.fp7" could not be opened. (Not Found) If I click the OK the open file opens and I can navigate to the tickets database in my solution folder. Selecting the file and then opening it makes my solution work. Any ideas on why I might be getting this message and a possible solutuion to my problem? Thanks