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