I have a table that combines 3 table's from another app(SBT)based in foxpro. I was hoping to keep it in one table for simplicity, however...I am displaying the information in a set of grids that are parent-child related IE order level then line level then item level then component level all related top level down. If I use cursors the load time is rather long and will only get worse as the table grows. If I use the tables again as the record source of each grid I have a duplicate record problem on the 2nd and 3rd level. From what I understand I should not use a unique index because of deletion problems. is there a way to avoid the duplicat records that I have overlooked or should I just go to using 4 tables?
Thanks...
Dan Rowe
Eagle Technology