Creating a new form for existing table & update ext. tab w/ new fi

D

Donna@alron

I am not a big Access user. Nor do I have experience with discussion groups.
I apologize in advance if I break any discussion group rules.

I have created a new form. I would like to update an existing table with
new fields and make some changes to existing fields and then associate the
updated table with the new form.

At the moment, 98% of the fields display "#Name?". I assumed this was
because it was not associated with a table. Please enlighten me.

Can I do that and if so, how do I do that?

Thank you in advance for your assistance,
 
J

Jeff Boyce

Donna

You may have approached your solution somewhat backwards if you started with
the form design and then are trying to make the table match up.

You will find much greater success (and much less maintenance/rewriting) in
the long run if you spend the time up front to model and normalize your data
first, then start on forms.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top