Database relationship problem
-
hello, i have a problem with the relations between 2 tables. I want to make a table with contacts and another table with websites. I want to have many website for 1 contact! SO 1 contact can have many websites. Can someone help me on this pls? Adrian De Battista: .Net Programmer, Java Programmer and Web Designer.
-
hello, i have a problem with the relations between 2 tables. I want to make a table with contacts and another table with websites. I want to have many website for 1 contact! SO 1 contact can have many websites. Can someone help me on this pls? Adrian De Battista: .Net Programmer, Java Programmer and Web Designer.
Naturally, the contact table will have a primary key (some sort of ID for each individual contact). The websites table will need to store this key also - but in the websites table it will be a foreign key (because it is the primary key of another table). The websites table will also naturally have a primary key of its own. Is this enough to get you going?
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question." --Charles Babbage (1791-1871) My: Website | Blog
-
Naturally, the contact table will have a primary key (some sort of ID for each individual contact). The websites table will need to store this key also - but in the websites table it will be a foreign key (because it is the primary key of another table). The websites table will also naturally have a primary key of its own. Is this enough to get you going?
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question." --Charles Babbage (1791-1871) My: Website | Blog
-
Hi Adrian, Are you using some kind of form in your .NET application as a database interface? If so, you can use an oleadapter/sqladapter to connect to your database. The procedure is quite straight forward (there is a Wizard). The data controls are on the Data tab of the Toolbox in the IDE. QC