Results 1 to 3 of 3

Thread: Database Relationships - Inform me

  1. Sep 10th, 2002, 03:58 PM #1
    squirrelly1
    squirrelly1 is offline

    Thread Starter
    Frenzied Member
    Join Date
    Jun 2001
    Location
    USA
    Posts
    1,026

    Question Database Relationships - Inform me

    I have heard of making relationships between Databases...

    What is this? How can I use it to my advantage???

    If it is useful, are there any good tutorials on how to do it with vb code???

    Thanx for your answers,
    Squirrelly1
    Now happily married and still crankin' away at the keyboard. Life is grand for a coder, no?
    Reply With Quote Reply With Quote
  2. Sep 11th, 2002, 04:00 AM #2
    aidan
    aidan is offline
    Lively Member
    Join Date
    Sep 2002
    Posts
    103
    What sort of database are you using? I don't think it's possible with Access/JET databases, although if you are using VB to access them then you could create the appearance of this with multiple queries.
    Reply With Quote Reply With Quote
  3. Sep 11th, 2002, 04:17 AM #3
    swatty
    swatty is offline
    Frenzied Member swatty's Avatar
    Join Date
    Aug 2002
    Location
    somewhere on earth
    Posts
    1,478
    Relational databases stands for the tables in the database that are related to eachother.

    You can relate tables to eachoter in Access as in SQL-Server.

    Each RDBMS (relational database management system ) is a system that organizes data into related rows and columns.

    The relation between tables is often made with a foreign key of the second table which is related to the primary key of the first table.

    Advantages, if you want to delete a row in the first table there will be an error that there is still a row in the second table which refers to the first table.

    It is also preferable for splitting up tables (Normal form) to not have redundancy.
    Code:
    If Question = Incomplete Then
   AnswerNextOne
Else
   ReplyIfKnown
End If
    cu Swatty
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width