Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select problem
Message
From
17/05/2007 13:17:24
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01226415
Message ID:
01226434
Views:
38
>>>i have a table named tb_account. inside this table i have all information about the account. i have four type of account. it cant be client,broker,carrier and propest. (its 4 different field). so an account can be one of them , or two of them etc... so if i want a select to retrieve all the client, broker account ??? how can i do that ?
>>
>>Sounds to me like normalisation is needed, if you have redundant repeater groups like this. I'd say there should be an account_type look-up table, with the 4 acc. types, and a link (m-to-m) table between them, giving client# and acc_type#.
>>
>>Then each client rec may have 1 or more of these link recs, depending on how many accs he has.
>
>Terry,
>
>Are you sure it is a "normalisation"? Or you're talking with British accent today?

As I understand it, yes - normalisation, removing redundancy. Here we have 4 fields where only one may be used. Also, in the future, if more acc types are created, then it's a simple job to just add them to the acc type look-up table.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform