tangierc

I have media databases that I am not sure how to merge and am afraid of messing of the relationship structure: Table 1 = list of tapes with portal to table 2 Table 2 = contents of tapes Table 3 = table made from Final Cut Pro columns (we add to this one by importing batch lists made from Final Cut Pro). Each row may have the same tape, but different description of the content at that point in the tape. Tables 1 and 2 = 1 to many relationship by unique id How do I get one instance of a tape name from Table 3 into Table 1 and get all of the contents for each tape from Table 3 into Table 2? The way this database is supposed to work is that for each tape you would be able to see (in the portal) the contents of that tape. I've already achieved this with the way Tables 1 and 2 are now, but Table 3 doesn't have the unique ID like the others.

I got it. The database that the script references was not being shared. Thoughthis database is not visible remotely, it needs be set for sharing so the script will work remotely. Tangier

My file path is fine on the computer that hosts the file. All databases are in the same folder. However when I log in to the database from another computer, the script won't run because it can't find the database. It's as though the remote copy doesn't know that the database it's looking for is governed by the file reference on the hosting computer. It's not adjusting it's network path and instead says the database cannot be found. Yet when I work on the database/script directly on the machine that's hosting the files, it works perfectly.

We are running a small database using FMPRO 8 for Mac OS X on a host machine and sharing it. Scripts that I've created will not work when I log into the database remotely because the remote side is looking for a database file that the script references. How do I get around this? It's as if the remote entry wants to know where reference files are locally. The script should work know matter where I log in from. Printing the barcodes has the same problem. The script I have to print barcodes (with our dymo) will only work from the machine the database is hosted on. What am I missing?

Got on the phone with filemaker. Turned out I had everything setup correctly. The file just became corrupt. Thanks for your help though. Tangier

Everyone has access to write to the records.

Essentially I have OS X server (10.3.9) as the OS on the machine that is hosting the FM file. I opened the file as an admin on that machine and made sure that it can be shared using FMs file sharing prefs. I made sure that privilege sets have read/write permissions as well as set the permissions for the file itself using getinfo so that others can write to it.

All is well with permissins and such. For some reason, the records created on he non hosting computers are created on the hosted file, but not actually visible to anyone. Its as if the file will only allow the person who created them to view them. This defeats the purpose of the shared file. I still can't figure this one out. This is really strange.

Yes. They have been instructed to press the submit button. The same thing happens with those using FM directly as well though.

Folks, I've got a database of one table shared. I have users in our office opening the database remotely, inputting records (via FMPRO or the FMPRO web interface) and they are not appearing in the database. Can anyone explain this? Lots of empty records are showing up. FMPRO 8.0v3/ database shared from OS X server machine

Here is the file (from Final Cut Pro and then one I saved as a text file). It seems that I need an xslt tow make Filemaker understand the Final Cut Pro xml file. I know nothing about xslt. sample.txt 16_kitchen.xml.txt

Apple's Final Cut Pro is able to save its data as an xml document. Filemaker Pro can import xml, but I have yet to be successful. Any suggestions and/or people who have tried this successfully? Tangier

I am just at the beginnings of trying to figure out how to use Filemaker to manage all of our (small office) audio as well as play it. Can FM 8 access the itunes xml file and parse it? I would like to get the iTunes data into Filemaker, but also play from FM. We can view and play music on our LAN using iTunes, but can't copy it to another machine

Folks, I have a database that references that value list from another database to display in one of its drop down menus. It only shows in the FM app itslef and not in the web published version of the database. Does anyone know how to fix this? Mac OS 10.4.6/ FM Pro 8

Thanks for that, but it didn't do anything. Maybe I did it wrong. What is appening is that my index field just adds an auto seial for each record. Oddly the last entry is 1517 (for 1517 records), but the database only has 1502 records. What I want to do is reindex so that the numbe of records matches the key index field. FM 8