autofill

[Valerie]

Okay, I guess I'm just an idiot. Very new to Access and
learning my way by trial & error. But I have spent hours
upon hours trying to figure this out and am now facing a
deadline.

How do I get data in one field to autofill based upon
data input in another field? For example, I have create a
table called Suppliers which includes a supplier code and
all the relevant info. I have created another table
called Parts with each part we carry, by part number,
including all the relevant info. Now I want to create a
Parts form which will automatically populate the Supplier
Name field when I input the Supplier Code field. Both the
Supplier Code and Supplier Name fields are included in
the Supplier form.

I don't know if the problem lies in my relationships or
where. Please help!

 

[John Vinson]

How do I get data in one field to autofill based upon
data input in another field? For example, I have create a
table called Suppliers which includes a supplier code and
all the relevant info. I have created another table
called Parts with each part we carry, by part number,
including all the relevant info. Now I want to create a
Parts form which will automatically populate the Supplier
Name field when I input the Supplier Code field. Both the
Supplier Code and Supplier Name fields are included in
the Supplier form.

Well, the Supplier Name is NOT AN ATTRIBUTE of the Parts table, and
there should not be a Supplier Name field in that table at all.

If you just want to *display* the supplier name, the simplest way is
to use a Combo Box on the form bound to the Supplier Code but
displaying the supplier name. That allows the user to just select or
type in the supplier name, rather than having to memorize or look up a
code. The user sees the meaningful supplier name; the table sees the
unique and stable supplier code; both are happy.