Auto lookup fill in function - Need more help

[Guest]

Thanks all for the previous advise. I still don't know what to do after I
read all the post. May be I can explain clear of what I want to do here.

I had a data base file from my accounting system which contain Customer Name
/ Customer Address / Customer Phone Number.

I had link that ( CUST_INFO ) table into a new database. What I want to do
is to create an Service call form for my service department to use.

So, I make a new table which had the following field :

Customer Name ( Using lookup function from table design base on info from
CUST_INFO )
Customer Address ( I would like this field to be auto fill the corresponding
information when the Customer Name field change )
Customer Tel ( I would like this field to be auto fill the corresponding
information when the Customer Name field change )
Service Call ID ( Auto number )
Problems report ( Text input )

I convert the table into using form wizard. Then what should I do ?

Thanks in advanced

D

 

[Michael Keating]

Thanks all for the previous advise. I still don't know what to do after I
read all the post. May be I can explain clear of what I want to do here.

I had a data base file from my accounting system which contain Customer Name
/ Customer Address / Customer Phone Number.

I had link that ( CUST_INFO ) table into a new database. What I want to do
is to create an Service call form for my service department to use.

So, I make a new table which had the following field :

Customer Name ( Using lookup function from table design base on info from
CUST_INFO )
Customer Address ( I would like this field to be auto fill the corresponding
information when the Customer Name field change )
Customer Tel ( I would like this field to be auto fill the corresponding
information when the Customer Name field change )
Service Call ID ( Auto number )
Problems report ( Text input )

I convert the table into using form wizard. Then what should I do ?

Thanks in advanced

D

Hi,

I think you need to re-evaluate the data you are storing.

One of the rules of relational databases (normalisation) is that any one
piece of data should only be stored in a table once.

You already have the customer data stored, with a customer ID I presume, so
to add service calls for the customers, you only need to create a table of
service calls, linked to the customer's table by Customer ID.

Something like ..

ServiceCall ID (auto number)
CustomerID
ServiceCallInfo

with the one-to-many relationship between this table and customers using
CustomerID.

To create a form that auto-fills the customer info, you first need a query
based on these two tables. Once you've added both tables, select CustomerID
only from the service call table, not the customers table.

By selecting the link field on the many side of the relationship, this
becomes an auto-lookup query.

You can use the form wizard to create a form, but make sure that the
CustomerID is a combo (change it after if necessary) with it's rowsource
being the customer ID and name (so that you select the name, but the combo's
value is the ID).

With the data set-up this way, when you select the customer's name in the
combo, the textboxes bound to the data in the customers table will
automatically fill.

HTH

MFK.