Help with some simple relations

[blueice]

Hi there,
I'm a bit stuck on this but it should be pretty easy.

Say I have a table secondHandCar - this contains infromation on the makeID (eg 123), price, number of doors. Now each car can have a number of images, this number isn't set so I have an images table...

tbl_secondHandCar
makeID - key
price
number of doors

tbl_images
makeID - key
Image (ole, binary whatever)

Now clearly I have a problem: the images table is going to have many makeIDs with different images. I've just got stuck here - do I need an image id or something? But then my make ID will still repeat in tbl_images.

Thanks for the help

 

[M8KWR]

i am taking that you makeID in the tbl_secondHandCar is an autonumber.

If so it would be worth having the same for the tbl_images tables. So make a field called imageID, and have this as an automunber for this table.

I am also assuming that you are having a subform to hold the images, so when you insert a new image it will get the makeID number from the tbl_secondHandCar and populate this into the makeID field in the tbl_images table.

Hope this makes sense, if not let me know.