drjmoo1

Update: When I delete the contents in the cache folders on the server the PDFs will load for the first time and then break again.

We have a Filemaker solution that stores a PDF in a container for users to view by clicking on the container and opening it in a web page. With Filemaker Server 12 all clients both on Filemaker Pro and Filemaker Go were able to open the PDFs without any issue. When we upgraded to Filemaker Server 13 the PDF container seemed to break on the GO devices. It still works without any issue on the Pro devices. The first hint that something is wrong on the iPad is the container field doesn't show the preview and only an 'icon' with the file name below. When you click on the button to open the PDF it loads at a white screen for a while and then it says "failed to open <filepath_on_server>". I have also tried just using the built in Filemaker go menu option "view" with the exact same error. Before we went into production with server 13 I was able to fix this by deleting the container field and adding it and then uploading the PDFs again. Now that the database is full of PDFs I don't really see that as a viable option. Is anyone experiencing similar behavior or have any troubleshooting suggestions? Thanks in advance.

Thanks for the reply comment. This is the intended destination of the link http://fmforums.com/forum/topic/49072-surveys-and-relationships/ Currently on the Evaluations table I have Semester, Year and Term. In acuality the Term value is "calculated" from the semester and year. The user inputs a year such as 2014 and a semester such as fall and the calculated value comes out as a valid term value of 201408. (this is just to match the imported applicant data from another system). But in effect this table is used for nothing more than to group questions by term, which I can remove if there is another way. In the reviews table I have a date/time field, a userID field, a comments field, and a reviewer name field. What does the double lined border around answers indicate in your diagram?

This is exaclty what I am trying to do. An applicant's "term" will never change from review to review. The applicant term is the only determining factor for the evaluation questions but each review for each applicant must be able to be referenced separately. I tried to do something similar to what was pictured in the diagram on this post (http://fmforums.com/forum/topic/49072-surveys-and-relationships/) but was unable to get it to account for seperate "terms." mrubenson: In more general terms I am trying to create something that will allow multiple reviewers at different times to review (answer questions on a 1-5 scale and record commments) a group of applicants from the applicant_profile table, by answering questions which are determined by the 'applicant term' field of an applicant_profile record.

Hi, I am very new to creating relationships in filemaker and am having trouble accomplishing a specific task. Currently what I have are 5 different tables. I have the tables applicant_profile, applicant_reviews, evalutaions, questions, answers. What I am trying to accomplish is the following: Each applicant in the applicant_profile table will be reviewed multiple times by a review panel that will store general comments and reviewer's userID in the applicant_reviews table. The evaluations table is the collection of the questions from the questions table that will be displayed to the "reviewer" and the answers table should be the answers to each question. The problem I'm having arises when I want to use another field from the applicant_profile table 'applicant term' that relates to the evaluation table in order to determine which evaluation to display to the reviewer. An applicant_profile record with 'applicant term' of 2013 should display different questions than an applicant_profile 'applicant term' of 2014. The evaluation which is displayed changes depending on the applicant_profile but we still need to refernce all of the reviews, the questions and answers later. Thank you in advance for your help