mike72

Check the sharing for the file under "File>>Sharing" menu - i had this same problem when migrating databases from one computer to another, and accessing the databases from another station. mike

I am having the same problem with 5.5 and 6 unlimited. The FM6 is on a 3.4ghz P4 with 4gigs of RAM, and nothing else running. It happens on a mac G4 as well. It is frustrating to have to restart the program, or worse yet, realizing that FM has crashed or slowed to an almost screeching halt. FileMaker has no answer except "check for patches?" or "restart the computer." Now I have read here other posts that claim FM 7 is slowing down as well. Anyone have any other experiences/ideas?

Brilliant! Thank you! File>>Sharing>>check the web companion box. As I assumed, simple. mike

Hi Garry (and all) I am struggling with the same issue above - getting the "database not open" message. I moved the database files from a PC to a MAC (for data entry) then back to a PC. The databases open, I can add data, but cannot access the databases with the browser. I have tried copying then renaming, recovering the database, etc. I did export the data, but Im not sure how exactly to clone a blank layout as mentioned above. I could delete all records in a copy, but I wasn't sure that is what you suggested. BTW - I had old copies of the databases (with the same name and same layouts) working just fine. Any ideas? Thanks, Mike

With John's suggestions - the lookup worked - and everything is working as it should now...I was barking up the right tree before, but was having issues with the "The field cannot be modified until 'blank' (field) is given a valid value." error message - probably, as Ugo stated, I had irrelevant relationships for lookup fields (e.g. "Country::Country") that should have only been related to "Town::Town". No idea why it took me so long to figure out something so easy - thanks! mike

Hi John In my database I am lucky enough to not have duplicate towns. Each record in my "second" database has a unique town name. Since the names of the towns are unique (each town name is not duplicated and has its own record with corresponding county, state, etc) - I am hoping that the unique town name will act as a serial (or zip code) being the unique identifier for the record. A user enters the town name in the "main" databases town field, that is related to the unique town field in the "second" database, and the fields related to that database should fill in....? Because some of the towns are in international locations and ones that clearly do not have a post code, I won't be able to use that option. But thanks for your suggestion! Any more ideas/help? -mike

Hi all - I've been searching around this and a few other sites and although there are some good tips and techniques here - I am still having a problem creating the following: I have a main database that has blank fields: town, county, state, country. In a second database I have filled in fields: town, county, state, country. In this second db there is only one instance of each town, but many towns in counties, etc. I want to type the name of the town in the main database and have the county, state, country automatically pop up in the corresponding fields. I know this is possible but I have been trying with no success...the closest I got was returned with an error message "The field cannot be modified until....". (p.s. if it isn't blindingly obvious already that I am a complete novice - please reply with step by step instructions!) thanks in advance, mike