Retrieve several photos from one Access record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In an antique inventory, I need to see up to 10 photos of an item (record).
they would be accessed 1 at a time or posssibly they could be shown thumbs
that can be chicked-on the retrieve the photo.

Many Thanks
 
Create a child table to your item table. Maybe call it tblItemPhotos
You will need at least 2 fields:
[ITEM_CODE] - or whatever you call your inventory item key
[ITEM_PHOTO] - This should be a hyperlink field

Create a directory to keep all your photos in.
Then in tblItemPhotos, create a link in [ITEM_PHOTO] for each photo. So, if
you have an item with 5 photos, there would be 5 child records for the item
record in your item table.
 
Back
Top