On Thu, 23 Oct 2008 23:11:01 -0700, nerak
wrote:

Thanks John

Looking at your investors table
If Bill Gates bought shares in his own name but also in his company name
could these both go in the same table?

Yes, with different ownerID's: one for the person, the other for the company.

The tables I have for investors are

Table 1
Table2ID
First Name
Second Name
Phone No
Mobile
Email

Table 2
Shares held in name of (If company involved)
ATF Trust
ACN


Do you mean you have a FIELD for ATF Trust, and another field for ACN? That's
*completely incorrect*. You don't store data in fieldnames.

Table 3
Table1ID
Table2ID
Address
City
State
Postcode

What real-life Entity does this table represent?

I have broken them up like this to avoid doubling up with input. I now need
to bring them together as one so I can relate them to the other two tables.
Is this best done with a table or query?

Anytime you want to bring data from two or more tables together you use a
Query. That's what queries *do*. Tables don't "do" anything other than store
data.

These are not what I have called the tables.

My Company table has:
Company name
ACN
TFN
Incorp Date
GST reg
Review Date......

You're speaking jargon that I don't know. What are ACN? TFN? GST?

My Shares table has:
Number of shares
paid value
percentage held
Share numbers
Certificate Number.....

But no indication of WHAT company's shares these are, nor who holds them????

hank you very much for your time and assistance so far.
--

John W. Vinson [MVP]