>>>>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.
My dictionary chokes when I spell it the same way you do :)
I'm sorry, I was just joking about improper spelling.
If it's not broken, fix it until it is.
My Blog