Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Field to hold multiple references
Message
De
08/01/2001 06:26:54
 
 
À
08/01/2001 06:13:11
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00460487
Message ID:
00460494
Vues:
11
>The fields will purely be used for display purposes only, they are references for a staff member.
>
>The field will hold the staff at the time the record was created, so all they will be used for is a reference/history.
>
>Is that what you meant?
>Kev

I was thinking along the lines of if it were only for historical purposes, then maybe a single field would be a possible way to go.

If you were going to display the data, then separate fields would mean that you don't have to separate out the data.

If the references were meaningful & may be used to look up other information (such as description of the reference), then separate fields would have distinct advantages.

On the whole, I couldn't think of any real reason for combining the data into a single field (especially not knowing what you were trying to achieve). I see in your reply to Len, that querying may be a possibility - knowing that would convince to to use separate fields.

If the references consisted of groups of meaningful data, it might even be worth thinking of dividing even further.
Mike

"I can live with doubt and uncertainty and not knowing. I think it is much more interesting to live not knowing than to have answers that might be wrong." - Richard Feynman
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform