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!

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.

--
Build a little, test a little.


"Ray_Rattler" wrote:

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