database relationship problem
-
hello I am working on one win app with sql database visual basic i have created 4 tables singlecustomer, jointcustomer, address and plotdetais. I have created relationship with all 4 tables singlecustomer with address and plotdetails second jointcustomer with address and plotdetails and then I have also created database diagram and it show all the relationships now when i drag and drop sql adapter to configure it database relationship dosent look right in query builder it's not showing correct relationship with all tables. in query builder when i add tables first time it's different relationship and then i canceled it and add tables second time with different order so it shows different relationship waiting for your kind help thanks
-
hello I am working on one win app with sql database visual basic i have created 4 tables singlecustomer, jointcustomer, address and plotdetais. I have created relationship with all 4 tables singlecustomer with address and plotdetails second jointcustomer with address and plotdetails and then I have also created database diagram and it show all the relationships now when i drag and drop sql adapter to configure it database relationship dosent look right in query builder it's not showing correct relationship with all tables. in query builder when i add tables first time it's different relationship and then i canceled it and add tables second time with different order so it shows different relationship waiting for your kind help thanks
Sorry I don't understand what your problem is, you can change the join in query builder if they don't suit your query. Seems you have almost no knowledge of databases and are relying heavily on the built in tools to do your work for you. I suggest you get a basic book on database design and start learning. Using a forum for your basic learning is NOT a good idea, get a book or do a course!
Never underestimate the power of human stupidity RAH
-
hello I am working on one win app with sql database visual basic i have created 4 tables singlecustomer, jointcustomer, address and plotdetais. I have created relationship with all 4 tables singlecustomer with address and plotdetails second jointcustomer with address and plotdetails and then I have also created database diagram and it show all the relationships now when i drag and drop sql adapter to configure it database relationship dosent look right in query builder it's not showing correct relationship with all tables. in query builder when i add tables first time it's different relationship and then i canceled it and add tables second time with different order so it shows different relationship waiting for your kind help thanks
Let me try to rephrase this for you using sentence structure: "I am working with a windows app with sql database and vb. I have created 4 tables: singlecustomer jointcustomer address plotdetails I have created relationships with all 4 tables: singlecustomer related to plotdetails and address jointcustomer related to plotdetails and address I have created the database diagram and it shows all of the relationships. When I drag and drop a sql adapter to configure it, the database relationships don't look right in the query builder. In query builder when I add tables the first time, it shows a relationship. When I cancel it and add tables a second time in a different order, it shows a different relationship" Now, that's what your question looks like with proper sentence structure...however, it still doesn't make a lot of sense.