Posted on 2005-05-12
I am creating a front end for a database. My knowledge is fairly basic in this area. I have for example got about 5 tables. I have one table with client details on. This will populate fields on the left hand side of my application. For every client there is usually more than one record. My database needs on the left hand side to navigate through the client records, and the right hand fields updating as you scroll through. Once you have settled on the client record, you need to be able to cycle through the individual clients records. (does that make sense)? Would I do this with two different datasets? Because if I need two sets of navigation buttons I am going to need to datasets arent I?