Lee J

To All FM Gurus. I have a system where i track our Time and Materials against our projects or jobs. This works on the LineItem process via a Portal and todate works really well. At the end of the Project i go through and "Flag" each of the items with are chargeable and ignore those that are not chargeable. This then presents me with a Invoice Value which i pass over to my Invoice DB. What has transpired is, some of the larger projects need to be Part Invoiced. But to make it a little more complex some clients request a break down based on categories. I have managed to create the Break downs and display, however i can't seem to find a way so that those items that have already been invoiced are not included in the next invoice stage. Thanks in advance FileMaker Version: 6 Platform: Windows XP

Cheers will take a look at the example and report back in the new year. Enjoy

Still not sure, perhaps i don't have enough Databases to create the many-to-many relationship from within my Estimate portal Currently i have the following db's. estimate.fp5 inventory.fp5 customers.fp5 estimate_items.fp5 Do i need another table?

OK so where i'm currently doing a lookup via a portal i need to change the fields so they become calculations. The Fee tables we need are fixed pricing based on a specific product type. Example To Mold a Plastic tub for Client A = $10 To Mold a Plastic tub for CLient B = $15 We also have a series of other sub functions which also carry variable values based on the Client. I'll have a go at your suggestions and see how i get on. Big thanks

Greetings to All I have been creating an Estimating system using a Portal to create the line items associated with the Estimate number. It now seems that my users requrie some form of a fee table to be used rather than entering the line items each time. My dilema is i have 5 differnet types of fee tables, associated across several differnet customer which may include different items. so as an exmaple here is what might happen New Estimate for Customer A preset costs from fee table 1 - Item A, Qty 1, $15.00 - Item B, Qty 1, $15.00 New Estimate for Customer B preet costs from fee table 2 - Item A, Qty 1, $10.00 - Item B, Qty 1, $10.00 If anyone has any ideas on how to tackle fee tables or Matrixes i would love to here from you. Filemaker Version 5.5 (Windows)

Hi To All I have a situation where i can't seem to validate against two fields I'm trying to create a Time and Date entry for a community hall and don't want people to be able to book the same time/date. So far i have created a number calculation field (DateReq + timeReq) to create a unique number. Then using a Submit script I copy the value to another field Validation field where i try to "Trap" the error and provide feedback to the user to say it has already been booked. I have used the Validate options under the Field Definitions but this results in them having to modify the Validate value which means nothing to the user. I really need to redirect back to the Time or Date field to change. Hope this is clear cheers

I'll give that ago, the other thought i had was that when I export, I can't do field matches as the import side of MYOB is fixed, so I have to export a series of dummy fields (text) but empty so that they line up in the MYOB import window. Is it possible these could be causing a problem?, If so should i perhaps change them to a Numerical field, or a container?

I think you have hit the nail on the head re-fields having carriage returns in. The last field to be exported is a text based field which contains a description of sorts. I thought I could be cheekiy and create a text calculation field and as part of the equation add a special ASCII 10 character at the end. However I couldn't achieve this. I had thought of an external option so will investigate and as mentioned I will look for a C++ programmer who enjoys working for Chips and Beer

Both products run under windows.

I have been trying to get MYOB to import data which exports from my FM solution. It seems that a CR is requried at the end of each line exported. and i can't seem to figure out how I can achieve this. If i manually edit the text file afterwards i can get the system to work, however with over 1000 exported entries this is not good. Any tips or tricks please. Thanks

Cheers Andy, Did try the URL but found it a bit limiting for what I wanted, Will try your Applescript step and see how things pan out. I have just got hold of a Macintosh so will be putting in some long hours learning Applescript. Big thanks from Middle Earth (NZ)

Being a windows user know need to create a sendmail script to drive Entourage on the Mac. My problem is I can't get Entourage to create a New mail message and transpose the details across i.e Subject, message etc. The PC works great with outlook. But my knowledge of Applescript is basic so could do with some help

Fitch, so what you suggest is in the script for the first portal row, Copy the unique Serial number to a global field. Go to the second layout with the other portal and use the Global field as the relationship to filter.

<Anatoli> You should read the message better. He doesn't say he has used FM5.5 for years. Anyway... WE run FMPro 5.5 here on a P4 under Windows 2000 pr SP2, 256meg ram, with no real odd ball applications running on Top. Todate we haven't experienced any crashes as you mention however we did experience and issue with a Network card which sent FM into a spin when accessing a FMServer situated on Windows NT4. we replaced the Net card with a Win2000 compatible device and it has been fine since.

<Psion> I have been trying to get to the URL you provided as I too have experienced no joy getting to an SQL server. This link seems to be outdated or void. Is there somewhere else I can go to get an update or Demo version?

Cheers Gary, I did think of this but was on sure what effect this may have on the system as I have several users entry data and I have heard that using Summary fields incorrectly can cause system slowdowns. Thanks again

To all that help, I have a field labelled "Qty" which serves two purposes based on the selection in a field called "Code" if the field "Code" is Time then the total will be "Qty" multiplied by the "Labourrate" field to give me a total. If I select Material the total wil be "Qty" multipled by "ItemValue". My problem is this I need to show a summary of Hours but because the Qty field is used for Time and Material I need to some how only total those in the "Code" Time. Any ideas folks??

Excellent, I have the filter working however, I have to have both fields completed for the filter to work. Have I done something wrong? It would be nice if they can enter "Username" or "Date" or Both and the portal displays accordingly. cheers

I have a portal which I need to filter via a specific relation. However the relation needs to be by user name and Date. I have a field called "Username" and antoher called "DateCreated" From a series of popup lists I need them to be able to select the user name and then a date. The portal will then only show the entries for those selections. any ideas? Huge thanks in advance

I have two reports which can include data on a single job or multiple jobs. Currently the Find ans Report request are perfomed in the time and material DB. The final calculation requires the system to divide the final total by a number value defined in the Estimate database. "TotalSKU" to give a "ProfitBySKU" value It works fine on a single job report but when I try to use this against multiple jobs it is incorrect. How can I get the total os "TotalSKU" from the estimate DB and transfer it to the T&M database so I can use it in the "ProfitBySKU" field?

What about creating a field with an HTML tag to create your link then export this field with the data? <A HREF="Filemaker field with URL">

I did try using this initially by using a loopthrough the found set, however when I had a quote which had 100's of items I ran into all sorts of difficulty. However I will investigate this option as my FM skills have improved somewhat over the course of this project. cheers

OK If I get rid of the Imports how shall I handle the Duplication of the Related records?. We generate automatic Quotes with many being similiar to the last, Hence the reason to Duplicate. I found the Importing to be good because I reduced the chance of any previous quotes getting completely overidden. Who else can I duplicate related records via Portal?

I have a quotation system with a script that Duplicates related items in a Line_Items db by first exporting the original items out, then performs a replace with new Quote Number, and then re-imports the original items back in. My scripts work ok running it locally, but when I Serve the databases via FMServer it fails to work. Any ideas folks?

I have just loaded up 3 new databases (all set with Multi Hidden) to our FMServer running WIN 2000 Server. The Log file says "Can't open Database because it is already in use. I have restarted the server but still no go. any ideas?: