Linking tables

[Dudley]

I have two tables, 'Company' and 'Director', which both have field
EnvelopeNumber. I am trying to create a form which has Company and
EnvelopeNumber at the top and (presumably) a Director subform below. I would
like to be able to search on EnvelopeNumber to find the correct company, and
then insert details of directors.

Can anyone advise or point me to a guide to this basic operation?

Thanks for any help.
Dudley

 

[Arvin Meyer [MVP]]

Build a combo box on a form which has 2 columns:

EnvelopeNumber
Company

Use the combo box wizard to create it. Set the column width of
EnvelopeNumber to 0"

Build a subform for the Director table which links on the EnvelopeNumber
field.

 

[Dudley]

Thanks very much for your help.

I have done this but I only seem to be able to add one director for each
company. Am I doing something wrong or does this method only allow a one to
one relationship?

Dudley

 

[Arvin Meyer [MVP]]

In the Director table's design view change the EnvelopeNumber to a
non-primary or non-unique index.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Dudley]

Thanks for your help.
Dudley

In the Director table's design view change the EnvelopeNumber to a
non-primary or non-unique index.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com