Question on best use of a Container field
Using Windows XP SP3 & FMP 10 When registering Claims on our system the USer needs to copy varios legally required documents before sending them by secure messenger to the processing centre. As part of each claim record we want to therefore keep a copy of the scanned document. This will be scanned and stored as a jpeg. 1. If I want to link it to the claim record, do we need to have a field for every separate document or is this where field repetition comes in? 2. As it is only the link that is stored in the database and not the file itself, when a backup and restore is done of the database f the files are not restored to exactly the same path, does the field show or report some sort of error i.e. that the file is now missing? 3. If the files are then restored, are the links repaired automatically?