Add field to Table

[gpurger]

I have a table of software defined as Y/N.
This is displayed as a subform on the employees form.

What I want to do is create a new software field on the table via a form, then when the employees form is opened the new field will also be displayed on the subform.

I would also like to do the same on a report.

Cheers

Gordon

 

[Mile-O]

I have a table of software defined as Y/N...What I want to do is create a new software field on the table via a form

By doing this you are going down a dodgy route and now, are finding out why.

Basically, a database should grow down (with records) and not across (with fields). The keyword here is normalization.

Have a read of my FAQ on 1st Normal Form (1NF) - your first consideration when designing tables for a database.

I haven't written an FAQ on 2NF or 3NF yet but, by searching here and with Google, you can find all the information you need.