Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Field to hold multiple references
Message
From
08/01/2001 21:20:05
 
 
To
08/01/2001 06:06:04
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00460487
Message ID:
00460959
Views:
11
>I have a table that needs to hold up to 5 8-char references. I was thinking of creating a 40 character field, and hold the references in there, but is there a better way of doing this, should I use 5 fields perhaps?

I'd say one field, but 8 characters long and in a different table with up to 5 records, that normalizes the data and lets you go above and beyond 5 records :-)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform