Autopopulate and add values

[johnshansen]

I am new to infopath and am creating a form that is connected to an
access database. I would like my form to be able to autopopulate
certain data groups (when possible), but also let me change and add to
those data groups.
As I type an old value into customer name, I want it to bring up
company, address, phone number etc. However, at the same time, I would
like to be able to add new information in for new customers, so that if
the customer name is new, I can type all of this information in to
these fields(and store the information in the database).
Is this possible, and if so how would I go about doing this?

 

[Adam Harding]

Hi John

Simple question really but complicated answer.

You could use a master detail form for such a thing look at
http://office.microsoft.com/en-gb/assistance/CH011097241033.aspx

For a full explanation and How to. You would have two buttons on the form
one for new record and one to search for the old one. You could then amend
all details and save and job done.

Do your research on Master/Detail first as it helps to get a good grip of
this.

Cheers Adam