how to display multiple pictures per record in an access database

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

Guest

I want to store and display (on a form or a report) multiple pictires per
record in an access database. The pictures are not stored within the
database. They are stored as files and the database contains the paths to the
pictures.
The database consists of two tables:

TABLE DATA
ID Name LastName

TABLE PICTURES
ID Path

I want to create a form displaying data for each record of TABLE DATA and
all the pictures (let's say aligned horizontally) for the particular record
from TABLE PICTURES (ID <-> ID). MS Access allows subforms to be added to a
form, but this doesn't solve the case, since subforms can be only displayed
in data sheet view.
 
One more question:

When DefaultView property of a from is set to Continuous Forms, the
records are aligned vertically. How to display them horizontally?
 
Back
Top