Field Link

Z

Zanstemic

This seems like a simple issue but could use help on how to best approach a
design issue.

I have two tables 1) Client 2) Representative with a one to many relationship.

In the Client Form, I have a combo box for selecting the many
representative. I'd like to have fields automatically fill-in with the
representative information once selected.

Any suggestions is appreciated
 
D

Duane Hookom

"fill-in with the representative information"... are these bound or unbound
controls? You can display other fields/columns from a combo box with control
sources like:
=cboRepresentative.Column(x)
Column number "x" is based on zero.
 
Top