Re: Can related Access form fields autofill after 1 field is entered?

RachelsFrustration wrote:
> I am trying to make the value of 2 fields in a form named "FRM-orders"
> relate. For instance, selecting a company's name (using a dropdown
> menu if possible) automatically fills in the company's ID number,
> both which can be found on a table labeled "TBL-Suppliers."

Proper Relational Database design would dictate that you not copy data
redundantly like that. Your order records should only store the CompanyID.
You can then use a query or any number of various lookup methods to DISPLAY
the customer name, but you should not store that as a field in the order
record.

An easy way to do this is to use a ComboBox for CompanyID with a RowSource
that pulls the CompanyID and CompanyName (second column hidden if you like)
from the Companies table and then in an unbound TextBox you can display the
data from the extra column with an expression like...

=ComboBoxName.Column(1)

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com



.