Hi Rich,  I set up a database which uses combo boxes.  However, instead of setting up the Attribute table with 1 field and then adding the items to this table.  I set up the attribute table with several fields (text fields), where each field is a selection in the combo box.  I would like to change the table format similar to your format so that I can create a form of the table to allow adding of attributes available in the combo box.  I would have to delete this combo field box and exchange it with the new one.  Is there a way to do this without losing the data in the other 1800+ records?  Thanks Andrew

---

Reply from Alex Hedley:

Does your Table contain an AutoNumber or is it just a Text value you are storing from the Combo selection?
If it had an AutoNumber which will change you could copy these attributes into your new table then do join from old to new and an UPDATE query to set the old value to the new AutoNumber.