Auto fill fields

[mms46373]

I'm trying to add a feature to an exsisting database where
by the user would select a field for example Vendor Name
and additional information specific to that vendor, i.e.
address, city, state, etc would autofill to those
particular fields.

I've created a separate table with Vendor info in it and
have created a relationship to my main table based on the
Vendor name.

I can't get the related info to auto fill.

Can anyone give me an idea on how to accomplish this?

 

[Van T. Dinh]

I am not sure from your description but it sounds like you
want to store *duplicate* data (Vendor details) in to
the "other" Table (e.g. a tblProduct, for example).

This is not recommended as it violates the Relational
Database Design Principles.

Correctly, you should only store the VendorID (or some
value(s) necessary and sufficient to uniquely identify the
Vendor in the tblVendor). When you need to use the
combine data from the 2 Tables, simply use a Query to link
the 2 Tables.

HTH
Van T. Dinh
MVP (Access)