John Browning

Thanks for the reply to my posting. I agree that keeping all the cost data in one file is a "solution" and possibly the "correct" solution but is it not a practical solution in this case. I developed this DB system in 1995 and have used it since to complete hundreds of costings, some very large. For simplicity and security it works best to keep a CostEst file as a separate entity in the folder for each job costing. This is also the way my users prefer to operate. Aside from this problem it works well as a relational database solution to the problem. Excel is definitely not the answer to the problem. Been there, done that! The method I have set up at present for each new costing is to use a script to create a copy of the master CostEst file and then save it into a selected folder, normally the current client folder for the job being costed. Providing the immediate previous CostEst file has had its name changed after the costing is complete FMP is then forced to ask for the location of the file as it cannot find it due to the name change. The dialogue box then enable the user to open the just saved new CostEst file and the links are then reestablished to the new CostEst file. This is cumbersome! If I am to perservere with this workaround I need some method to rename a file without leaving FMP and manually renaming the file in the folder. Any further suggestions, anyone???

You will need to create a new database for each answer called, say, Answer DB 1, 2, etc. Each AnswerDB will need to have a key field which could be, say, the record number in the ResponseDB for each response. You will also need a database for the response called, say, ResponseDB Then create a relationship for each AnswerDB in the ResponseDB with the match field being the key field in each AnswerDB. Check "Allow creation of related record" in each relationship. When you enter the answer in the ResponseDB it will create a new record in the relevant AnswerDB. You should then finish up with all the answers to a specific question in the relevant AnswerDB. Good Luck!

I need to be able to relink a moved file to other files in a master folder. The FMP setup is as follows: I have a cost estimating solution I have written in FMP. The solution relies on scripts and lookups to move cost data from a set of master solution files into a job CostEst file. For each new costing one file, the CostEst file, is duplicated and moved into a new folder elsewhere on the hard disk. It is then given a new name, say CostEst.230204. The rest of the solution files stay in the solution folder. The problem is this: The duplicated CostEst file relationship keys still relate to the solution files as the solution file location hasn't changed. However the solution files cannot link to the moved file as both its location and its name have changed. Hence, when a script is run from the CostEst.230204 file it happily goes to the relevant Master solution file but then cannot move data back into the CostEst.230204 file as it doesn't know where it is! I can fix this by opening the relevant script in the Master solution file and relinking the "External script" to the new CostEst.230204 file. However this is cumbersome. I also noticed that the External script referenced file is always the last new CostEst file created, which is logical but dangerous as the script then opens the previous CostEst file and pastes data into it, thus modifying the wrong file! I need either a work around or a plug in or some suggestion as to how to enable this link to be moved to the new CostEst file for each new CostEst file created. Incidently the solution is used on both Apple and Window OS's.