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
Printable View
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
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.
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.