linking 2 images tables to one master

[agy001]

Hello

I am trying to link 2 image tables into one master. I had to break up my
master image table, apparently I exceeded the 2 gig limit. Now, I have 2
image tables 1 gig a piece. the table that I want to link to has 500 records.
Unique ID 1-500 , I broke my image tables into 1-250 and 251-500 as there
Unique ID. I can't seem to link both tables to the master. In attempting to
create a relationship, I either get the "1-250 table" linked or the other,
but not both. can anyone help?

thank you!


thank you!

 

[Doug M]

You can relate your master table to two separate image tables, but the
fields in the two image tables are different so you can't for example create
a form for the master record and put an image on the form because there are
two different image fields. You would have to put the image field from both
image tables on the form, and then one or the other would show the image you
want depending on the master record.

One option to consider is to link the images as external files instead of
storing them in the database.

Doug