> I have 2 databases of the following format.
>
> A Files database
> FileName
> FileNumber
> FileDate
>
> A Data Database
> FileNumber
> Data
>
> A File record will have many related Data records (100's perhaps 1000')
>
> The way my app works is that when I save the data, I first save a single
> File record then basically 100's if not 1000's of Data records containing
> data. Depends on when the users stops the recording of data.
>
> I bring up a FileList table which displays All the files previously saved.
>
> I select the file I want and then it finds the related Data records based
on
> the file number. Problem is that I have to open the related Data records,
> look at the FileNo to see if matches the selected FileNo of the selected
> file and if it does display the data. The real problem is that this
process
> is time consuming.
>
> Does any one have any ideas how I could better do this.
>
Yes. Roll back the design, viz:
A combined File and Data database
FileName
FileNumber
FileDate
Data
Data
Data
--
For information on using the Palm Developer Forums, or to unsubscribe, please see
http://www.palmos.com/dev/tech/support/forums/
