It has been a long time since I have been back to my database and have decided to try and ascertain the best way to do my major problem that was holding me back, storing images.
Basically for every piece of equipment there can be many inspections and for every inspection there can be many pieces of equipment --> For every piece of equipment and every inspection there can be many images of the equipment
Obviously the major limitation is the 2GB database size limit for access, however unfortunately I like the attachment field.
For every piece of equipment I would like to have all the images joined to the equipment and also to the corresponding inspection as well so I have put this field into the junction table.
What I would also like to do is be able to add multiple images at a time (this is done easily with attachment)
Also I would like to be able to view images from past inspections for a particular piece of equipment (on forms preferably live)
Additionally I would like all the images linked to a certain piece of equipment and inspection to be printed automatically on a report
This obviously needs to use links as per the database size however the best way that I can see is with the attachment field. Is there any way to change the attachment field to link to attachment rather than storing it directly into database?
Thanks