473,326 Members | 2,168 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Table structure & relatinships with OLE Objects

1
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
Oct 7 '08 #1
2 1417
FishVal
2,653 Expert 2GB
Hello, Fred.

I suggest you to read Database Normalization and Table Structures article.

Also, you may find some interesting info in The BLOB (not the movie!), but first of all you should redesign your tables.

Regards,
Fish.
Oct 8 '08 #2
NeoPa
32,556 Expert Mod 16PB
How appropriate it is to be pointed in the right direction by Fish himself :D

Read the article. It is actually very good, and aimed at beginners and experienced database programmers alike.

As far as your design is concerned, consider that whenever you have the opportunity to have multiple possible items related to any individual item, it is better to store them in a separate table and link them, than trying to store them within the same table.

I hope that makes sense, and Do read the article anyway.

Welcome to Bytes!
Oct 8 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: QWERTY | last post by:
--------------Boundary-00=_O5I3QL80000000000000 Content-Type: Multipart/Alternative; boundary="------------Boundary-00=_O5I3LVC0000000000000" --------------Boundary-00=_O5I3LVC0000000000000...
1
by: mksql | last post by:
As an example, I am building an authentication mechanisim that will use data in the 3 left tables to determine rights to objects in a destination table, diagrammed below. In this structure,...
19
by: Thomas Matthews | last post by:
Hi, Given a structure of pointers: struct Example_Struct { unsigned char * ptr_buffer; unsigned int * ptr_numbers; }; And a function that will accept the structure:
10
by: Peter Kirk | last post by:
Hi there can someone please help me with creating dynamic content in a table? For example, see the below javascript and html - why is a new row not created in the table when I click the button?...
5
by: xah | last post by:
i'm just starting out on javascript. can anyone show me how to go about writing a code to sort a table column? something like the following: <table border="1"> <tr> <td>
5
by: Shibu | last post by:
Hi, I have a situation where I need to convert business objects to a flat table. The reverse is also required. I am using c# and Oracle ODP. I am looking for an easier method to do the below...
6
by: polocar | last post by:
Hi, I'm writing a program in Visual C# 2005 Professional Edition. This program connects to a SQL Server 2005 database called "Generations" (in which there is only one table, called...
2
by: Dave Ekhaus | last post by:
hi i'm new to javascript. i'm hoping to get some help and find out if what i want to do is possible and - assuming it is, get some tips on how to accomplish the task. ok - assume i have a...
4
by: =?iso-8859-1?B?UmVu6SBKZW5zZW4=?= | last post by:
Hello I got a problem with a class i'm trying to create. the problem is that i would like to use the dot when i access some parametes in the class like. Connect()
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.