Printing records & images in order

[jesus_hairdo]

We have a database which has a series of personal records in it. For each record there are an unknown number of images.

What i would like to do is to print out all of the records and images in the correct order.

So we would have record1 + all of the images for record 1, then record 2 + all of the images for record2. and so on.

In the records table there is a membership number, the filenames given to the images contain this membership number and some random strings.

Any suggestions on how i go about doing this?

TIA.

Jamie

 

[chenn]

Do you have a table of filenames for the images? If so, are they related by membership number? It would be easiest to link them and then create a report / query and just sort it. If not, then you have to do alot of parsing the information to retrieve the records first associated by membership and then ordered by image.

If the images are not in the database, you need to get them there. You can do a file search and load every image from a directory and then start the process of parsing the file names and so on and so on ....