how do i simplify this kind of tables in sql
create table table1(tb1ID int not null identity(1,1) primary key
,name varchar(50)
,BSUN1 varchar(50)
,BSUN2 varchar(50)
,BSUN3 varchar(50)
,BSUN4 varchar(50)
,BSUN5 varchar(50)
)
can I use just single variable for BSUN and Component? if so then how would I insert value and (select then populate multiple textboxes from DB) ...my friend mentioned using array but I have very limited knowledge in array, so anyone can help me with this? .