Image database

[Guest]

How to store multiple images for one unique ID in Access?

 

[Guest]

Hi Rad,

To store multiple anything for a single unique ID you need a second table
that stores that anything.

eg:

tblMain
MainID autonumber
MainStuff text

tblMainSub
MainSubID autonumber
MainID number (links to MainID in table tblMain)
MainSubStuff text

That way, for each unique MainID (and Main information, eg: Name, Date, etc)
you could have multiple items recorded in MainSub. Personally I would store
a text reference to the path/filename for the photo rather than the photo
itself - but that's a seperate question.

Hope this helps.

Damian.

 

[Guest]

Hi Damian,
Can you explain what is MainStuff text and mainSubStuff text?

 

[John Spencer]

Examples of other fields that you may want in the main table and the sub
table.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

Hi,
I have two tables. One contains person detail such as,
id(autonumber),name(text). Another table contains
id_sub(autonumber),id(number),picture(text). I linked the tables using
relational table. In this case I linked id in the first table with id with
second table.
I made two forms. for the first and the second tables. But my second form
'id' does not update according to the first form. Can you please help
regarding this?
Thanks

 

[John Spencer]

Did you include the second form as a SUB FORM on the first form? And set
the link Child and LinkMaster fields to ID and ID?

That is the only way to automatically populate the ID numbers between the
two tables.

Otherwise, you are responsible for entering the correct ID in the
"subordinate" form.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

Hi,
I included in a subform. i linked id of each table using the relationship
table. But when i open the form it doesnt show any pictures. But when I open
the subform only, it shows a image. But Id value is not the same as the
parent ID value. Can you tell me how to set the link Child and Link Master to
ID. Does it come automatically when I build the form?
Thanks!

 

[John Spencer]

Build the master form
Base it on a query of the master table (do NOT include the subordinate
table)

Build another form based on the subordinate table (do NOT reference the
master table)
Close the subordinate form

Open the master form in Design view
Click on the subform button and click on the master form
Select the subordinate form you have built and add it.
-- The wizard should propose setting up the linkage between the master and
subform.
If it doesn't, then once the form is added, click once on the subform
control and the properties of the subform control should include a place to
specify the fields to use in linking the two.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

Thanks! it works now

Build the master form
Base it on a query of the master table (do NOT include the subordinate
table)

Build another form based on the subordinate table (do NOT reference the
master table)
Close the subordinate form

Open the master form in Design view
Click on the subform button and click on the master form
Select the subordinate form you have built and add it.
-- The wizard should propose setting up the linkage between the master and
subform.
If it doesn't, then once the form is added, click once on the subform
control and the properties of the subform control should include a place to
specify the fields to use in linking the two.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..