Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Field to hold multiple references
Message
From
08/01/2001 06:26:54
 
 
To
08/01/2001 06:13:11
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00460487
Message ID:
00460494
Views:
10
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform