BankyToo

To be more exact, I will be getting the data from FM into the other program (SPSS) using SPSS's query function. SPSS is able to query DB's and retrieve the info. The query function does allow me to indicate relationships but the actual performance is unreliable at the moment and I am not familiar enough with the query function to solve the problem. It seems to me the best plan is to use the query function in SPSS to retrieve the date from a flat spreadsheet in FM. jon

You are right that visit information will be collected but I am a little unclear on your suggestion. In the final part of this project I will have to export all the data. Using this method I don

OK, here is the deal-e-o, First, I think it is best that I give a representation of what I am working with rather than all the files and such. There are actually 24 forms that are administered anywhere from 1 time to 11 times over 11 visits. I have provided an example, a representation, of the different challenges I am facing with this database with fewer files. This database will be used locally

Hello, I am building a database in fp 6 and I was hoping to get some feedback at the planning stage rather than when I am pulling out my hair. Data will be entered into 5 separate forms and will be captured in 1 filemaker file. I am planning on creating the 1 file and then making portals in 5 files all pointing back to the master file. I am choosing this method because changes made in either file will show up in the other file and the data in the master file should export successfully. I may add some buttons to move the user from one form to the other but that is down the road a bit. Any feedback would be greatly appreciated. Thanks Jon

Hello, I am fairly certain this has been answered in other questions but I was unable to apply it to my question, so please bear with me. I am using filemaker pro. Here is the situation. I gave 5 different surveys to a bunch people once a week for a bunch of weeks. Right now each survey has its own file with all the people and all the visits in each file. So in each file there is a person ID and a visit ID. Now I am trying to get all the data into one layout. My thinking is that I would like tell FMP to give me (person1, 2,

I am using FM 6 pro. Is there a way to get my script out of FM so that I can edit it in another program? I have a set of functions I need to perform on 15 different files. I am thinking if I can get the script out I can use the find/replace command in Word to change the appropriate info and put it back into FM. thanks jon

Steve, Thanks for the thoughts and input. The problem with the portals is that it does not show up as a variable when the stats program queries FM. Right now the previous suggestion (import all data into one file) is looking like the way to go. I am thinking about creating the label names in another program and importing them, then defining the fields in FM. thanks again jon

I did think about that and it may be the answer. The downside is that we will be peeking at the data with a stats program as it is being entered in FM. So I would have to "import/replace old data with new" when we would want to take another peek. The biggest advantage to entering the data in seperate files is that there will only be 1 occurance for each person, rather than making sure that the same visit it not being entered more than one time. So I like the lookups becuase i can "relook" when I need to but I am not sure it is worth it. thanks for the thoughts, opinions, and experience. jon

Hello, I am familiar and a bit savvy with excel and SPSS but this is my first time making a database. I am creating a DB with repeated measures. For example, we have a 10 question (q1, q2