Data in data sheet to fields in another table

[Ray_Rattler]

I am working with a database where I have a Category Description field in a
Categories table, and I would like to create a table (Table 1) that has all
the different Categories as fields.

The problem is I want to be able to update the Category Descriptions through
the use of a form, and have it update the Table 1 fields to include the new
Category without deleting values in Table 1. This will probably be a
multiple step operation. A little help would be great!

 

[KARL DEWEY]

Having multiple data as field names is the wrong thing to do in a relational
database.
You can use a crosstab query to produce field names and if you follow it
with a make table query it will do what you want.