I know how to display these pictures without having them embedded in the tables.
The form is bound to a table with PK=autonum. I have a table=tPicNames
Expand|Select|Wrap|Line Numbers
- Key AutoNumber (PK)
- ptr Long Integer (FK)
- FileName Text
- PicOrder Long Integer
- ...
Expand|Select|Wrap|Line Numbers
- SELECT FileName FROM tPicNames WHERE ptr=1234 ORDER BY PicOrder
So I will need to know if I have zero, one, or many pictures for this Key. If not zero, I will need to get the Text of the first picture (which is the picture name).
I could do this with a .visible=false ListBox on my form, a form which is hidden, or a recordset (which I don't know how to do.)
What is fastest?
What causes least bloat?
Does it matter if most records have many pictures? If most have only one picture?
If using a recordset, should it be freed each time new key, therefore new query?