Fred Young

Hi guys! Thanks for the heads up, now I removed all portals, sorts and unsorted calc. Now I have a last problem. It takes like over a minute just to open the database. The Database contains approx. 8000 records and is the size of 16mb, without the records it's approx 5mb... Must each of my remote users download the entire database upon connecting or why does it take so long just to open it? My opening scripts only adds 4 values to global variables, running a simple check filemaker version script and goes to my "home" layout. Thanks for all the help.

Hi. I do realize that the solution will be acting as the main email client, never mind that... I just need a way to store emails sent and received to each client so that we can track the email conversations... Plug in seems to be the only option... Sad... I really don't want to spend any more money on this solution... Any other options are most welcome. Thanks everyone for your help so far.

Hi everyone. This is what I've got and the story of my problem. I have a Solution with approx 2000 clients, 10 staff, 50 products and about 30 manufactures. It has Several Layouts, portals and relations. Also, script triggers and calculated value lists and validations. I got a host "MacUSA" but it takes almost 30 seconds just to enter the first layout. If I create new records it takes about 10sec before something happens and the same if I create new portal rows (ie. Note Utility) and just swishing between records has a delay on 5 seconds. I got 1 BIG portal that contains 4 check

Hi! I got a quick question. Is there any way to make my Filemaker solution to send and recieve emails strait from within my solution? I need the outgoing and incoming emails to be saved like a "chat" or "log" so that i can follow the Email conversations for each and every client in my database. There will be multiple users and they will all be using Gmail. Really really grateful for any help I can get. Thanks Freddy

I'll try to describe my problem as detailed as possible... I got 2 tables. Clients and Products. On the client layout i got a 3 dropdown lists "EmailProd1", "EmailProd2" and "EmailProd3" and they are getting their values from the Value List ProductList from the Product Field "ProductName" so that the dropdown list contains of all my products. I want a button now that sends an Email to the clients email and IN the email, it should write out the "PruductName" AND a short description from the Products field "ProductDesc" In the calculation, I said to write out "EmailProd1", "E

First off, my Filemaker Pro "Skills"... I know how to create some relations, simple scripts and calculations but nothing advanced really... I got a database with several Layouts and Tables. 1 Layout and Table, Staff Management, is for adding staff and Database users. Then I have a layout and table, Client Management, in which I want to create 3 Value List based from the Staff Management In the Staff Management i got a field "Name" and a Checkbox "Department". The Checkbox gets its values from a Value List "Departments" and has the custom values: "Sales", "Marketing" and "Adm

Okay, let me see if I can explain this simple and short. I'm not brand new to Filemaker Pro but I'm not very skilled ether. I know how to create some relations, simple scripts and calculations but nothing advanced really... I got a database with several Layouts and Tables. 1 Layout and Table, Staff Management, is for adding staff and Database users. Then I have a layout and table, Client Management, in which I want to create 3 Value List based from the Staff Management In the Staff Management i got a field "Name" and a Checkbox "Department". The Checkbox gets its values fr

Thanks everyone!!

Hi! I'm using Windows 7 and Filemaker Pro 10 Advanced. I'm having a field "Phone 1". This field is for local Mobile Numbers (10 digits) As someone enters a number XXXXXXXXXX, I want it to reformat automatically to XX XXXX XXXX. What kind of calculation do I need to do... I'm brand new to calculations... Thanks for all the help I can get! /Fred

Background: New to Filemaker pro, got the hold of the basics, but yet to learn the correct "Filemaker Language". Problem. I've been using the "contact management" template that comes with Filemaker Pro 10 Advanced. The "Notes function" creates a timestamp when the note is being made. It will print out "11/30/2009 2.23pm by FredYoung" The timestamp is made from a calculation: "Month ( Date_Created ) & " / " & Right ( Year ( Date_Created ) ; 2 ) & "By: " & UserName_Created" were "Date_Created" is a "Date-field" with Auto-Enter Creation Date. What I need is

It worked! I got it working! Thank you a million times! I've been sitting for 12 hours trying to figure this out and I was as simple as that! Thank you!

My background: I'm brand new to Filemaker Pro and I just got version 10 from my boss. I'm know HTML and Java but don't know to much about databases. I been playing around now for about 3 days, starting to get the very basics. My question: Database1.fp7 got 3 fields, (Name, Number, Street). Database2.fp7 got a scroll down list, where i manage to list all the "Name" from Database1. How do I make the "Number" and "Street" to automatic come in to Database2 from Database1 from the right record depending on what "Name" i pick in the scroll down list? I don't know if I need to do a

My background: I'm brand new to Filemaker Pro and I just got version 10 from my boss. I'm know HTML and Java but don't know to much about databases. I been playing around now for about 3 days, starting to get the very basics. I'm running it on windows 7. My Problem: I Used the Contact Management template to create a customer registration database and a Hotel List Database. I changed the values so they would fit for my use. Now, in the customer registration database, I've got "current_hotel" and "Hotel_number" as scroll down lists. I manage to link the "current_hotel" to my seco