Re: Relationship question

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Properly designed tables do not include combo boxes. See:

http://www.mvps.org/access/lookupfields.htm

Yes you need a relationship between tables. Add a CompanyID field to the
contact table so that you have a connection.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Lori" <Lori@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:05E1A0EB-1D74-452E-82C7-883408321F49@xxxxxxxxxxxxxxxx
I have a database that records information on contacts and company
information. I wanted to add to this database a table to record all our
insurances. The table would include a combo box's -SQL statements to pull
the company name from the company table and the agent and carrier names
from
the contact table.

My question is, do I have to establish a relationship even though there is
a
relationship to two different tables and there really doesn't need to be a
joined field? Then again if the names change, will they update in this
new
table if they are not joined?

If I really should have a relationship...please advise how to set up a
relationship with two tables.


--
Thank, Lori


.