sbrash03

Thanks... Your example attatchment was very helpful. I actually had scrubbed the manual for a similar solution but was not able to answer the question. Much appreciated. - Stephen

As usual I have a problem. I want to add PDF files to a container field in a sales database. I then want to 'double click' on the file icon (in the container field) and have Acrobat open up automatically and display the PDF. If I insert the file into the container as a 'file reference' there is no problem. BUT... (there's always a but) this is not what I want because I cannot guarantee that I can maintain the integrity of a completely separate file structure holding all the PDFs (there may be thousands) over the years that this database is hopefully used. Rather, I want to import the entire PDF file when I insert it into the container and store it now in FileMaker. But the ability to 'double click' the icon and have it open the file now seems to be lost. So... how do I write a script to open an embedded file in a container field from within FileMaker ? Thanks in advance for your help. - Stephen

Thanks, I appreciate the help

I'm endeavouring to build a sales database where we use containers to store scanned PDF's of client contracts. We are trying to apply the seperation model concept in our database with the records and calculations in different files from the layouts (primarily for security and ease of development for multiple FMP7 developers in the office). All has been fine so far until we tried linking container fields from seprate files on to the layout in questions. The container name on the table is "greyed out" and will not work. All other fields, value lists and calculations work just fine. Do containers not work accross multiple files ? Do they need to be embedded into the same file as the layout which they are linked to ? Say it ain't so. Any comments on the subject would be appreciated. Thanks - Stephen

Cheers ! Thanks

Has anyone had any success with writting a script (or maybe thee's a built-in function I'm not aware of) to get FM7 Pro to open everytime on a specific layout, irregardless of the layout it was closed on. I am trying to get it to open to a "main_screen" layout each time it is opened by a user. Any feedback would be appreciated. Thanks,

Any suggestions on how to change a specific graphic based on a field condition. Here's what we're trying to do: I am creating a project management database which will catagorize projects into various "stages". We have a number of unique graphics which represent the various stages of the project. Based on the stage of the project which the user chooses (drop-down list) the graphic at the top of the PM layout changes. Any suggestions on how to accomplish this ? Thanks, Stephen

Thanks

I'm new to relational databases and even newer to FM7, so forgive me if this comes accross as a total newbie question. Here's the scenario: Two tables : 1. 'customer_details' (client ID, client name, address, etc.) 2. 'customer_contacts' (client ID, contact type, time & date, details) It's a one to many relationship. One 'customer_details' record could have many 'customer_contacts' records associated with it. Both tables have a common field 'client_ID', which is auto-entered by FM in the 'customer_details' table when a new record is created. Once a new customer record is created, there is button on the 'customer_details' form to take the user to the 'customer_contacts' form where they can create a contact record for that customer. THE PROBLEM: I want to client_ID field in the 'customer_contacts' table to be auto-populated based on the last client record that the user came from ? I have a one-to-many relationship created between the two 'client_ID' fields in both tables but the field is not auto-populating. Any suggestions for the newbie would be appreciated, Thanks.