cartographer

For some reason, this equation only autoupdates, when I select the field in question, or close and reopen the Filemaker document: If(index>1;If(index+skip ≠ index; GetNthRecord ( addtoindex; Get(RecordNumber)-1 )+skip;GetNthRecord ( addtoindex; Get(RecordNumber)-1 )+1);index+skip) where index, skip, and addtoindex are all fields. and this equation gives the results for addtoindex itself. Calculation result is a number. Number of repetitions is 1. Do not evaluate if all reference fields are empty. Storage options is set for Do not store calculation results. And no Global storage is checked. Filemaker 8.0v3, soon upgrading to version 8.5 for the Mac. Will this be improved in 8.5, or do I need to do something else that that every time I change the value of skip or index, addtoindex updates without my having to select it first or close the document?

Bumping an old question here which never got answered. Anybody have an idea?

1.7 Department of Astronomy at UC Berkeley - Extrasolar planet search 1.8 "Bill's 14.5 inch telescope making project" - A detailed look at building your own telescope. 1.9 Celestron International - manufacturers of binoculars and telescopes 1.10 Dean Dauger's Solar System Simulator for the Macintosh 1.11 European Space Agency 1.12, 1.13 Extrasolar Planet Encyclopaedia - in French and English, with mirror site. 1.14, 1.15 Keck Observatory and their news page

The database is one where I have a list of links on a webpage that is running off a PHP based guestbook program. http://www.macmaps.com/astronomy.php is the example. I have already separated each numeric entry in the white portion of the website into their own records on Filemaker. If I wanted to add an entry, naturally all the numbers have to shift upwards one number ahead of that entry. If I wanted to remove an entry the reverse would have to happen. The problem right now is creating a numeric field where the entry value doesn't get lost when deleted from the index since I may want to reuse it. I used to run this fine in Excel, but I'm wanting to stop using Microsoft Excel and move to Filemaker as it seems a lot easier to sort values, and saves me an extra step of having to send everything over to BBEdit to do an additional sort.

I've been trying to find out how to define a field that has an integer value that auto updates each time I create or delete a record. Each row below is a record in Filemaker for that field: 1 2 3 5 7 8 If I were to insert a record at 7, it would change the value of 7 to 8, and the value of 8 to 9 and automatically insert the value 7 at that record. If I were to delete record 7, record 8 would change its value to 7 in that field. How do I setup my field to have that characteristic?

Thank you. I was having trouble with the built-in Tiger ODBC administrator hooking up into my MySQL server. Is that what I should be using? It seems to want SQL servers that are Windows Centric. Or is there a way to get it to recognize MySQL on a server over the internet?

I haven't yet purchased Filemaker because I don't yet know what tools I'll need to do the integration, but given that I've read there is SQL integration with Filemaker, I was hoping someone could give me a hint on how to proceed. I currently have a very archaic setup with a webhost that offers me Linux webhosting and PHPMyAdmin access. Unfortunately, PHPMyAdmin has difficulty handling my tab delimited text files which I currently export from Microsoft Excel and parsing it so that it imports into the SQL database. Since I don't know enough about PHPMyAdmin, and neither does my webhost, I'm sort of stuck with the odd process of having copy/paste into BBEdit, remove the tabs, sort, and export to a flatfile textfile that a PHP Parser is able to view. My database consists of 20 textfile tables with tabs removed, with a total right now of 1550 records. Some records have fields as long as 2000 characters. A total of 10 columns is common through the tables, and it has a variably increasing index sometimes increasing 2 to 30 values at a time with some tables not starting their index at 1 but a much later value like 200. 1. Are there any text field types with no length limits I can give an SQL database? 2. Can Filemaker run a mathematical query like =3-LOG10(E33+1)+1 and plug that in another field? 3. Can Filemaker be set to sync with an SQL database on a Linux server without having to deal with PHPMyAdmin? What addon tools are the least expensive? Are there any pitfalls I might run into?