sorry for not being more detailed in my explanation. The Table in question(A) was created to combine data from 3 tables in SBT. The three table in sbt are the order level,line level,and a component level the order level would have one record, the line level could have ? (say 3 line items for that order),the component level could have ? (say 3 components that make up the item on the line). I combined the dat from all 3 tables int to (A) and ended up with 9 records. 3component levels for each line on the order.The order number is on each record as is the line no and so on. This worked great until I needed to present all levels to the users VIA a grid for each level. When on the order level or line level the grid will have 9 duplicate records showing. There should only be 1 on order and 3 on line. These are free tables. So I only wanted the unique key for presentation in the grid Unique is a no no. Thats why I was leaning towards having multiple table instead of one(A). Thanks
Thanks...
Dan Rowe
Eagle Technology