Multiple container fields

[The_Crofter]

I am creating a database to track scientific instrumentation. Many items require a yearly calibration and it is important to keep records of previous years results. I wish to place the cal sheets as individual PDF's in container fields.

Do I have to create multiple containers manually and then populate with files or is there a technique to do this automatically ?.

This idea will be used for equipment photographs as well.

I guess another way would be to create a scrolling text box that has each line as a link to an image, PDF etc. However I have not seen any facility for adding this type of format to text.

[Genx]

I suggest you add one table, with at least the two following fields:

RelatedID_FK

Container

Anywhere you need multiple containers, just relate that to your main table.

If the answer was a bit hopeless, just post back.

[The_Crofter]

I think it is me that is hopeless !.

How will this work ?.

[Genx]

Why does everyone put themselves down so much?...

Sigh, my explanation really was kind of bad.

Take a look at the attached i put together for you.

example.zip

[The_Crofter]

Thanks for the reply. All I have to do is remember not to use the mouse wheel to try and scroll in the portal - I just move to the next record !.

Cheers