Hi Gina -

It sounds like you might be understanding what I am trying to do...

I have a bunch of prospective companies. And there are really 2 main models
I am looking at. One company with one contact who manages multiple
properties OR one company with multiple contacts who each manage multiple
properties.

All the fields are pretty straightforward with the company table. The only
tricky one with the contact table is the Business_Phone. I want to be able
to see the phone number I entered in the company table so when I run a query
on a contact, the main business phone number shows up. And the only tricky
one with the property table is the contact name. I want the first and last
name of the contacts I entered for any given company to show up here so I can
assign contacts to each property within the company.

Steve made a note about adding a correspondence table into this database.
The more I think about it, I think that is a good idea. With the
correspondence table, I would be able to record date, message, collateral
info that was communicated to prospective client. That new table would need
to relate to the contact table.

Once all the basics are set up, I would also like to be able to do a few
additional things....

- Email prospective clients directly in Access
- Upload marketing collateral into prospective client database so it is
easily emailed through Access
- Create a current client database (with service request log table built in)
- Ability to transfer info from prospective client database to current
client database once a contract is signed
- Email current clients from current client database directly in Access

The more I write the more I am realizing that this isn't as simple as I had
originally thought!!!

Any brilliant suggestions?

Thank you!


"Gina Whipp" wrote:

Fred,

Thank you... starting think I had read something wrong!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Fred" wrote in message
...
From the given information, there is certainly a strong possibility that
Gina's added filed/link is the way to go.

And from the given information, ruling it out is certainly en error. So
Steve's making of a "NO-oooo!!! That is wrong!!!!" statement at that point
is
certainly itself an error , and making it that way was rude.



.