|
Home > Archive > BizTalk Server General > April 2006 > Database Design
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| MVince 2006-04-01, 2:38 pm |
| I am in real estate and am trying to build multiple databases in Access..(1)
a property log (2) an owner log and (3) an investor log...I understand how to
build these databases and build relationships; however, I would also like to
be able to monitor all contacts, i.e. phone calls, and schedule appointments
and make tasks...
I am also familiar with the Business Contact Manager and I like how this
software allows for the contact management, but I would rather be able to
query data in access.
Is there anyway to build the above mentioned tables with relationships
between the property log and owner log, then the owner log and investor log
that allows for invesors who are not owners to be input, and also monitor all
contacts with those listed in the investor log in the Business Contact
Manager without having to double input any data?
Any help would be much appreciated.
Thanks
| |
| Tomas Restrepo \(MVP\) 2006-04-01, 2:38 pm |
| >I am in real estate and am trying to build multiple databases in
>Access..(1)
> a property log (2) an owner log and (3) an investor log...I understand how
> to
> build these databases and build relationships; however, I would also like
> to
> be able to monitor all contacts, i.e. phone calls, and schedule
> appointments
> and make tasks...
>
> I am also familiar with the Business Contact Manager and I like how this
> software allows for the contact management, but I would rather be able to
> query data in access.
>
> Is there anyway to build the above mentioned tables with relationships
> between the property log and owner log, then the owner log and investor
> log
> that allows for invesors who are not owners to be input, and also monitor
> all
> contacts with those listed in the investor log in the Business Contact
> Manager without having to double input any data?
>
> Any help would be much appreciated.
MVince,
Sounds like you got the wrong group; this one is related to BizTalk Server.
You might want to ask again in one of the outlook or access newsgroups to
get some advice.
--
Tomas Restrepo
tomasr@mvps.org
http://www.winterdom.com/
|
|
|
|
|