15,886,110 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View Python questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by daveofgv (Top 4 by date)
daveofgv
2-May-16 23:24pm
View
Thanks ppolymorphe. I just updated my original question.
daveofgv
2-May-16 9:59am
View
Thanks for the replies. Yes, the relationships are very obvious to me since I created them. However, not sure if I am doing it the best way, but after I create the relationships - I always drag the fields from the Data Source Window over to the form, and that creates the Binding Source and Navigator.
Before I create the relationships:
tblClient
ClientID
FirstName
LastName
tblFile
FileID
ClientID
FileNumber
FileDate
tblReceipts
ReceiptID
FileID
ReceiptNumber
ReceiptDate
tblCoSigner
CoSignerID
ReceiptID
CoFirstName
CoLastName
Then my relationships look like this:
tblClient - tblFile (1 to many)
tblFile - tblReceipts (1 to many)
tblReceipts - tblCoSigner (1 to many)
After the relationships the Data Source Window now has:
Client Table
ClientID
FirstName
LastName
-tblFile
FileID
CleintID
FileNumber
Date
-tblReceipts
ReceiptID
FileID
ReceiptNumber
-tblCosigner
CosignerID
ReceiptID
CoFirstName
CoLastName
tblFile
FileID
ClientID
FileNumber
Date
-tblReceipts
ReceiptID
FileID
ReceiptNumber
-tblCoSigner
CosignerID
ReceiptID
CoFirstName
CoLastName
So with the above, you see how tblCoSigner was placed in two different tables, as well as, outside of the table. Also, the other tables are placed inside other tables that there is a relationship with. When I drag a column over to the form to create the binded text box, how do I know for sure which ones are going to use the relationship when they are a child of several other parent tables.
Hope this make sense in trying to make this easier for you.
daveofgv
1-May-16 23:00pm
View
That is a fair question. I am sorry I didn't explain it all the way.
I created a database in SQLite (outside of Visual Studio). I clicked "New Data Source" and connected to the already made database. I then opened the Data Source Designer and created the relationships there. After you save it the Data Source now has tables within tables since they now have relationships. I have a picture, but cannot see where to upload it for your viewing.
It would be a lot easier if I uploaded a picture so you can see. Is there a way I can send you a pic?
daveofgv
17-Apr-16 12:14pm
View
Thank you for the reply. I will look at third party products for this. I accepted your solution and will close this question.