table design question

[krberube]

I currently have a DB ( which runs good) with a table called RMAOptions. This table contains (by column) lookup data for list & combo boxes, IE.

column 1 = TECHID
column 2 = STATUS
column 3 = so on and so forth

Is it cosidered acceptabe to have a table like this or should each column be in its own table. I don't have any problems with this now, just wondering if there might be some in the fuure?

Thanks
Kevin

 

[krberube]

Glad I asked! I couldn't forsee any problems with this ( but being a newbie...) let me make sure I understand this.

This would take the place of my current (spreadsheet type) table. Using whatever headings i choose.

tblCodes:
CodeID (autonumber primary key)
ShortName
LongName
ParentID (foreign key to CodeID)
ActiveFlg (yes/no)
LastChangeDt
LastChangeBy

I like the idea of the Active flag!

Thanks!
Kevin

 

[krberube]

Thanks for the tips! Should work quite well.