I really need some help with this one. I am using VS2008 Standard, Access 2007 and VB.net.
I have an Access db with a Membership table, a DuesPayment table and a table
linking the two together.
tblMembers lnktblMembersToPayment tblDues
________________________________________________________________
MemberID* MemberID* DuesPaymentID
Name DuesPaymentID* YearDuesPaid
Address Amount
etc. etc.
1) In VS I have a single form (frmMembership). I used the Data Sources window to create a single datasource containing the tables tblMembers, tblDuesPayment
and lktblMemToPay. from the 'Data Sources' window I drug tblMembers, as text boxes, to the form. I drug tblDuesPayment to the form as a DataGridView.
I right-clicked 'dsMembership...Edit in Dataset Designer' and checked that the relations between the three tables was as shown above.
I left all other settings as they were created by VS.
When I execute the app I get the member information as expected and can use the TblMembersBindingNavigator to step through the members.
The DataGridView, instead of showing dues payment information for the member showing on the form, shows ALL of the dues information for ALL members does not exhibit any relationship between tblMembers and tblDuesPayment.
2) I also tried creating a dataset for tblMembers only. Then I used 'dsMembership...Edit in DatasetDesigner' window to create a TableAdapter for tblDuesPayment and lktblMemToPay. I got the same results.
3) I tried various other combinations, like creating TableAdaptors for tblMembers and a TableAdaptor for a combination of lktblMemToPay & tblDuesPayment.
I have very little hair on the top of my head from trying to pull it out over this problem.
Any help or suggestions would be greatly appreciated.
I have an Access db with a Membership table, a DuesPayment table and a table
linking the two together.
tblMembers lnktblMembersToPayment tblDues
________________________________________________________________
MemberID* MemberID* DuesPaymentID
Name DuesPaymentID* YearDuesPaid
Address Amount
etc. etc.
1) In VS I have a single form (frmMembership). I used the Data Sources window to create a single datasource containing the tables tblMembers, tblDuesPayment
and lktblMemToPay. from the 'Data Sources' window I drug tblMembers, as text boxes, to the form. I drug tblDuesPayment to the form as a DataGridView.
I right-clicked 'dsMembership...Edit in Dataset Designer' and checked that the relations between the three tables was as shown above.
I left all other settings as they were created by VS.
When I execute the app I get the member information as expected and can use the TblMembersBindingNavigator to step through the members.
The DataGridView, instead of showing dues payment information for the member showing on the form, shows ALL of the dues information for ALL members does not exhibit any relationship between tblMembers and tblDuesPayment.
2) I also tried creating a dataset for tblMembers only. Then I used 'dsMembership...Edit in DatasetDesigner' window to create a TableAdapter for tblDuesPayment and lktblMemToPay. I got the same results.
3) I tried various other combinations, like creating TableAdaptors for tblMembers and a TableAdaptor for a combination of lktblMemToPay & tblDuesPayment.
I have very little hair on the top of my head from trying to pull it out over this problem.
Any help or suggestions would be greatly appreciated.