Hi all
I am a real pled here, so I am not entirely sure how to structure my question so I will just tell you what I want to achieve and what I have done and see if there is a solution.
The information is in relation to fish, so I will describe in short the information and their releationship.
What I am wanting to do is to display all of the fields in both tables on a single form and to be able to scroll through them using the data navigator as per normal.
A fish may have a single scientific name, but may have many common names.
A fish may have a single form.
The form has a name, description and an image (BLOB)
A fish may have multiple images (BLOB)
To achieve this I have created 2 tables. I created 2 tables because the BLOB in the tblForms is common so I saw no point in putting multiple instances of the same image in a single table.
tblFish
ScientificName (text)
CommonName (text)
Image1 (OLE Object)
Image2 (OLE Object)
Image3 (OLE Object)
Image4 (OLE Object)
tblForm
FormName (text)
FormDesc (text)
FormPic (OLE Object)
In actual fact I have around 10 tables, but this is the part I am having issues with. The rest works satisfactorily and I have been able to create the respective relationships.
In fact it would be great if I could place all the Images from the tblFish into a serparate table and create a separate navigator just for those on the same form. Not sure if that is even possible though. Doing that would reduce realestate on the screen.
I don't know how to create the realtionship between the 2 tables so that I can build the form to display all of the information.
Ultimately this will be the backend DB for a VB application.
If I am going about this all the wrong way then I would like to know now.
Any thoughts and/or comments would be most helpful.
Many thanks in advance
Fred