Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Field with several values
Message
 
To
16/06/1998 04:51:32
Misson Bernard
Cddp de L'Aisne
Laon, France
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00108553
Message ID:
00108619
Views:
24
>How to indexe a field with several values (a slash with separator) ?
>Example : Author : Smith, J./James, H.
>
>I wish a cdx index.
Misson,

Normalize your data into a book table and an author table. The author table has one entry for each author and the book table has one entry for each book. Theh use a thrid table to relate books to authors where may be more than one record for each book and or author.
Previous
Reply
Map
View

Click here to load this message in the networking platform