alter table question

[Galena]

I frequently need to alter an already existing table by adding a column where
the end user would need to update a check box. For example, they'd check off
whether someone has an authorization form on file or not. Currently, I'm
writing a data definition query to update the table where I say:

alter table [my table] add
my column yesno

When I go back to the table, I see the values of zero in the column and I
want to see a check box. I have to manually update that in the table design
view. Is there a way to write the query so that the check box appears right
away?

 

[Tom Ellison]

Dear Galena:

If there are such needs, metadata is probably a better approach. I stongly
recommend you look into this. It allows you to do this without changing
table designs.

Tom Ellison