MohitK

Got it, thanks!!

Hi, I want to create a field in a table that auto-calculates based on a calculation of many related records More specifically, I have a table of Contacts (name, e-mail, etc.) and a Table with a one-to-many relationship called Events that are events relating to these people. e.g., Phone call with Fred on August 6th. I want to create a field in contacts which can be displayed in list view and will hold the date of the last event relating to the person. i.e., automatically look at all the related events, find the most recent and output the date. I want this to be updated automatically (E.g., a new event gets entered, the field changes) and work for existing contacts as the database already has a good amount of data. Anyone have any ideas? I'm a bit of a newbie, so the answer may be simple. Thanks!!

Hi. I am the original client Tusif referred to in the original post. Tusif has made a CRM-type software for us with this moo-plug script being the next piece. Situation: The filemaker database will sit on a mac shared server in the office (Mac Mini) being accessed by (4) local computers (3 MSFT XPs, 1 Mac). As well, as we are using an independent server, we will likely expand to allow non-local users access as well i.e., in other offices that are in the shared network. We want to create a button that would easily allow the upload of files that are linked in the database to a particular record. The script would: automatically move the file from the person's local hard drive to the server (mac mini), create a directory, and rename the file. Regardless if the person who uploaded the file is connected, anyone can go on the mac server and access the file via filemaker or outside in the normal file directory. The script with the issue is written below: http://fmforums.com/forum/showtopic.php?tid/212679/post/347318/fromactivity/myposts/#347318 As mentioned, I'd be willing to pay a suitable amount to resolve the issue and keep the conversation open for future work on the database as we expand. Please reply to the post or message me privately if you are able to help. Thanks!!