Hey. I am working on some sort of client + project management system. Each client can have many projects, many projects can have many staff. The Link (Junction) table allows for many staff members to be linked to the projects. I have attached the relationships which have been put together in Access 2007. Firstly, is this correct?
In order to display the data in my VB forms, I am making use of OleDb, by having a OleDbDataAdapter and DataSet. I am using SQL queries to select, insert etc data from the original database tables.
My issue; I can't work out the best way to link the data together so it can be viewed on one form. So once I access Client 1, I can see the projects they have with us, and then within that, all the staff they have working on that project.
I am not looking for the code, but suggestions for the best way to handle this in VB.Net.
I am using 2008 Express Edition.