Thank you for your post.
In FileMaker Pro, when you insert an Audio file into a Container field, there is a checkbox option at the bottom to "Store only a reference to the file". At this point, FileMaker Pro will only link the full pathname to the file. When FileMaker Pro then goes to play the contents, it finds the file through the pathname. When you transfer the database file to FileMaker Go, the file cannot be found since the pathname doesn't exist. Instead, when you insert the Audio file, uncheck the checkbox so that the audio file is stored with the database file. That way, when you transfer the database file to the iPad (or iOS device), the audio file also is transferred and can be accessed.
Let me know if you need additional clarification.
I can't find this checkbox option anywhere. In FMP 12 you insert an Audio file via the insert menu and then Quicktime. I can't find it there. I don't see it in layout mode or under manage database. Thank you so much for responding so quickly. Please let me know when you can what I am overlooking.
So, I found the check box under the browse mode and then right clicking on the container field and selecting "Insert Audio/Video". At the bottom of that window is the check to "Store only a reference to the file". I think I over looked it before because it was never checked in the first place. I had strored the songs on both devices. The issue I was having was that I was referencing the songs on both the Mac for FMP 12 as well as the iPad, thinking that once I did a sync the FMP version would eliminate the FMGo version. It finally worked after I cleared all references to the iPad stored music files completely out of the iPad container fields. Then I made sure that the "Store only a reference to the file" was unchecked and then loaded each song into it's respective container field in FMPro.
Finally after a sync from FMP to FMGo all was right with the world.
Thank You TSGal. It was you statement: "That way, when you transfer the database file to the iPad (or iOS device), the audio file also is transferred and can be accessed" that sent me down the right path of eliminating the path.