>>>>>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.

Do you mean yours has a "z"? There are lots of words like this where British spelling is an "s" and US is a "z".

IU thought you were questioning my inter0pretation of normalisation. :-)