Auto fill of fields

[algar]

I have 2 tables. One is JOB the other is CUSTOMERS. I would like to be able
to open a form in JOBS and after entering the CUSTOMER ID, I would like the
fields for Name, address, phone etc to fill in automatically. Can anyone
help me make this work? I have tried using Combo boxes but this forces the
user to select for EACH field individually and could create input errors.
Thanks for any help.

 

[John W. Vinson]

I have 2 tables. One is JOB the other is CUSTOMERS. I would like to be able
to open a form in JOBS and after entering the CUSTOMER ID, I would like the
fields for Name, address, phone etc to fill in automatically. Can anyone
help me make this work? I have tried using Combo boxes but this forces the
user to select for EACH field individually and could create input errors.
Thanks for any help.

How are the JOB and CUSTOMERS tables related (if at all)? Are you trying to
*copy* fields from one table to the other? If so, don't; that's not how
relational databases work! Data should be stored only in one place, and you
would use Access' tools - Queries, Subforms, Combo Boxes, and the like - to
display information from different tables in conjunction.

 

[Steve]

If you just want to display Name, address, phone etc, base your form on a
query that includes your Job and Customers tables. When you enter the
CustomerID, Name, address, phone etc will automatically fill.

Steve
(e-mail address removed)

 

[algar]

Thanks for the reply. The two tables are related by CustID field. The JOB
table also has its own unique ID. The concept is that when you record work
done for a CUST, you would call up the Cust info along with particulars about
the job.

 

[John W. Vinson]

Thanks for the reply. The two tables are related by CustID field. The JOB
table also has its own unique ID. The concept is that when you record work
done for a CUST, you would call up the Cust info along with particulars about
the job.

If you're working on a Form, it's pretty easy. You can have a Form based on
the customers, with a Subform based on the job table, using the CustID as the
master/child link field. Put a combo box on the form to *navigate to* - not
copy! - the record for the desired customer, and you'll see the data for the
jobs on the subform.

If you're trying to work directly in the JOB table datasheet - well, don't;
that's not what tables are for. They're for data storage, not for editing
multiple tables.