Jump to content
Salesforce and other SMB Solutions are coming soon. ×

One to Many ?


Recommended Posts


I have a database that has been developed for me for my fine art photographs.

I have a table of Galleries (who stock my work)/Table of all my images etc.

I want to list all the images the gallery got delivered under a delivery note number eg 021107.Trouble is I can't work out how to approach this but I think I need a one to many relationship and possibly a join table?

Can anyone instruct me how to do this? I attatch a link to 3 screenshots.





Link to comment
Share on other sites

It looks like you need four tables: Gallery, Image, Delivery, and LineItem. Gallery has a one to many relationship to Delivery, via GalleryID. LineItem is a join table between Image and Delivery, and thus needs the foreign keys ImageID and DeliveryID.

Link to comment
Share on other sites

  • 4 weeks later...

I have a similar question. Can anyone point me to a free online tutorial on how to setup a many-to-many relationship via a junction table. I am a novice and sure that I'm doing something silly but have been at an impasse for a couple of days. I'm sure its out there but I can only find paid tutorials / trainings online.


In case anyone is interested, the specific database is tabulating patient surveys for a volunteer ambulance service. I want each survey to be linked to the crew members who responded to the specific call. Later, we will need to run reports by crew members with survey results. The tables are setup as follows:


[crew] --> [jxnTable]


Thanks you...

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use