relational database

Can you tell us more?

Like what sort of database are you using (Access, MySQL, Oracle etc), what do you want to achieve etc..

Question was a bit vague

Take care

Bruce

Yes,please be a bit more specific. Are you having a problem connecting to an existing database or do you need help developing a database for your project?

Aloha

Bill

I am having trouble getting the relational aspect to work. This is what i am doing.

I create a databae call it data1

I create one table call it Table1 and another Table call it Table2

In Table1 I have

id - Primarykey
Name - (fieldclass)
Phone - (fieldclass)

Table2

id - Primary Key
url - (fieldclass)
Notes - (fieldclass)
table1id - fk

Basically what I want to do is have the table1 be the main table and have table2 have multiple responses.

For example

Table 1 -

John
555-555-5555

notes 1 - here are some notes
notes 2 - here are more nores
notes 3 - more responses
notes 4 - more responses

Name - Jeff
Phone 888-333-4433

notes 1 - nores
notes 2 - notes
notes 3 - more notes.

and have this be the process. When I do it I keep getting a relation error. I can't seem to update the child before the partent or vice versa and I have followed video tutorials and so on. I would appricaite any help anyone can give. It is really slowing my progress and is the only thing that is keeping me from completing the rest of my projects.

Thansk.

What database system are you using?
Are you using Referential Integrity?
How are you accessing the data? ie ODBC, DAO, Direct Connection, etc...

I am using sql compact edition that comes with visual basic pro 2008.

I went to the to the msdn site and watched forms over data videos with massi and followed them step by step but still don't work.

Another thing you might consider is to use a third table that contains 2 columns, one for the table 1 primary key and the other with the corresponding primary key from table 2. If you have several table 2 entries that are related to a single table 1 entry you just add a line to this new table. This arrangement will handle one-to-many and many-to-many relationships while breaking the direct relationship between tables 1 and 2.

Bill