Linking 3 images to 1 record

[alexfher]

My database has a unique field (caseno) that I use to link an image with. All the images are in a separate directory. Whenever a new image is imported into the directory, I change the image name to match the data in the unique field.

I was asked to store a possible 3 images per record so I modified the form by adding a pageframe with a pagecount of 3.

Does anyone have a suggestion on how to link the other two images.

Thanks,
Alex

 

[alvechurchdata]

It sounds as though you need a separate table of image names so that you can implement a one-to-many relationship between records and images. It just needs two fields: one to hold the caseno and the other to hold an image filename.

Don't solve the problem for three images - you 'll get a request for a fourth image the day after you get it working.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[white605]

I saw a discussion of using a grid for something similar in
thread 1254-1114677
wjwjr