Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unique Index ?
Message
 
To
20/12/2000 18:03:09
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00455521
Message ID:
00455704
Views:
29
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform