Hello All! I have a rather abstract question for some genius out
there to answer. I want to integrate communication tracking, for
customer relations, into an existing Access DB. What I was going for
is this...
tblCommunicatio ns trxCommunicatio nThreads
----------------- -----------------------
CommunicationID (PK) CommID1 (FK1)(PK)
ContactID (FK from contact table) CommID2 (FK2)(PK)
Content (text)
Date
Both CommID(s) in trxCommunicatio nThreads will reference a record in
tblCommunicatio ns. The end goal is to be able to store, track, and
display entire communication threads and the contacts that the
communications are from, kind of what you would see right here in
Google except not as robust. When a contact posts a follow-up to
communication1, the follow-up communication, communication2, will be
added to tblCommunicatio ns as a new record and a relationship between
communications 1 and 2 will be recorded in trxCommunicatio nThreads.
The problem is querying these tables in such a way where it will
display all related threads. The first layer is easy of course (i.e.
the first follow-up to an original communication), but it's the
follow-ups to the follow-ups that I can't quite figure out because it
would require some sort of recursive lookup. Is there a way to write
a recursive query? I can crunch through the trx table and create
thread relationships between communications with code, of course, but
it just seems like there should be a more direct way to do this.
I hope I am not being too elusive here. Please let me know if you
need further detail; although, it's hard to put this concept into
writing using only text.
Thanks to anyone that has any ideas. I have some thoughts of my own
but I thought I'd see what the rest of the community has to say about
this sort of thing before I got heavy into building it.
Bryan 3 1963
Hi,
I don't think you can make a single query who will return the full thread of
messages.
Instead, I'll suggest you another approach:
Create a temporary table and populate it with all the messages.
This can be done with VBA (creating the temp table, and populate it with the
communications messages, and deleting the table when is no necessary to
display the thread). The table can be created into a external MDB, created
also "on the fly" or on a "per session" basis (to not bloat your main
database with deleted tables).
Another approach, which will allow you to get all messages from a
communication with a query will involve a different data structure.
You'll need to have a threads table (you'll add there a record for each new
communication thread started). Then for each message it will have two
foreign keys: Thread ID and ParentMessageID . Also you can assign message
order ID for each message in the thread (actually this can be a timestamp
field), and with a single query you'll be able to retrieve all messages from
a given thread.
If you need any more help on this, you can contact me back.
Regards,
Bogdan Zamfir
_______________ _____________
Independent Consultant
"Bryan Christopher" <bh*****@medlin k.com> wrote in message
news:d7******** *************** **@posting.goog le.com... Hello All! I have a rather abstract question for some genius out there to answer. I want to integrate communication tracking, for customer relations, into an existing Access DB. What I was going for is this...
tblCommunicatio ns trxCommunicatio nThreads ----------------- ----------------------- CommunicationID (PK) CommID1 (FK1)(PK) ContactID (FK from contact table) CommID2 (FK2)(PK) Content (text) Date
Both CommID(s) in trxCommunicatio nThreads will reference a record in tblCommunicatio ns. The end goal is to be able to store, track, and display entire communication threads and the contacts that the communications are from, kind of what you would see right here in Google except not as robust. When a contact posts a follow-up to communication1, the follow-up communication, communication2, will be added to tblCommunicatio ns as a new record and a relationship between communications 1 and 2 will be recorded in trxCommunicatio nThreads.
The problem is querying these tables in such a way where it will display all related threads. The first layer is easy of course (i.e. the first follow-up to an original communication), but it's the follow-ups to the follow-ups that I can't quite figure out because it would require some sort of recursive lookup. Is there a way to write a recursive query? I can crunch through the trx table and create thread relationships between communications with code, of course, but it just seems like there should be a more direct way to do this.
I hope I am not being too elusive here. Please let me know if you need further detail; although, it's hard to put this concept into writing using only text.
Thanks to anyone that has any ideas. I have some thoughts of my own but I thought I'd see what the rest of the community has to say about this sort of thing before I got heavy into building it.
Bryan
Bryan
Using 'nested set theory', (a googles of 'Joe Celko' will explain the
model), I've emailed you a small mdb that might be of help bh*****@medlink .com (Bryan Christopher) wrote in message news:<d7******* *************** ***@posting.goo gle.com>... Hello All! I have a rather abstract question for some genius out there to answer. I want to integrate communication tracking, for customer relations, into an existing Access DB. What I was going for is this...
tblCommunicatio ns trxCommunicatio nThreads ----------------- ----------------------- CommunicationID (PK) CommID1 (FK1)(PK) ContactID (FK from contact table) CommID2 (FK2)(PK) Content (text) Date
Both CommID(s) in trxCommunicatio nThreads will reference a record in tblCommunicatio ns. The end goal is to be able to store, track, and display entire communication threads and the contacts that the communications are from, kind of what you would see right here in Google except not as robust. When a contact posts a follow-up to communication1, the follow-up communication, communication2, will be added to tblCommunicatio ns as a new record and a relationship between communications 1 and 2 will be recorded in trxCommunicatio nThreads.
The problem is querying these tables in such a way where it will display all related threads. The first layer is easy of course (i.e. the first follow-up to an original communication), but it's the follow-ups to the follow-ups that I can't quite figure out because it would require some sort of recursive lookup. Is there a way to write a recursive query? I can crunch through the trx table and create thread relationships between communications with code, of course, but it just seems like there should be a more direct way to do this.
I hope I am not being too elusive here. Please let me know if you need further detail; although, it's hard to put this concept into writing using only text.
Thanks to anyone that has any ideas. I have some thoughts of my own but I thought I'd see what the rest of the community has to say about this sort of thing before I got heavy into building it.
Bryan
Thank you, everyone, for your input. I have a great idea of what I
will do now. If anyone needs anything, ya'll know how to contact me.
Thanks again,
Bryan le*********@nat pro.com (Roger) wrote in message news:<8c******* *************** ****@posting.go ogle.com>... Bryan Using 'nested set theory', (a googles of 'Joe Celko' will explain the model), I've emailed you a small mdb that might be of help
bh*****@medlink .com (Bryan Christopher) wrote in message news:<d7******* *************** ***@posting.goo gle.com>... Hello All! I have a rather abstract question for some genius out there to answer. I want to integrate communication tracking, for customer relations, into an existing Access DB. What I was going for is this...
tblCommunicatio ns trxCommunicatio nThreads ----------------- ----------------------- CommunicationID (PK) CommID1 (FK1)(PK) ContactID (FK from contact table) CommID2 (FK2)(PK) Content (text) Date
Both CommID(s) in trxCommunicatio nThreads will reference a record in tblCommunicatio ns. The end goal is to be able to store, track, and display entire communication threads and the contacts that the communications are from, kind of what you would see right here in Google except not as robust. When a contact posts a follow-up to communication1, the follow-up communication, communication2, will be added to tblCommunicatio ns as a new record and a relationship between communications 1 and 2 will be recorded in trxCommunicatio nThreads.
The problem is querying these tables in such a way where it will display all related threads. The first layer is easy of course (i.e. the first follow-up to an original communication), but it's the follow-ups to the follow-ups that I can't quite figure out because it would require some sort of recursive lookup. Is there a way to write a recursive query? I can crunch through the trx table and create thread relationships between communications with code, of course, but it just seems like there should be a more direct way to do this.
I hope I am not being too elusive here. Please let me know if you need further detail; although, it's hard to put this concept into writing using only text.
Thanks to anyone that has any ideas. I have some thoughts of my own but I thought I'd see what the rest of the community has to say about this sort of thing before I got heavy into building it.
Bryan This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Ayende Rahien |
last post by:
Is it possible to use events as a communication mechanism between threads?
|
by: Noel |
last post by:
Hi,
I am a tad confused about if there are any benefits from using
asynchronous vs synchronous network communication.
As my example, I have been writing a dns lookup stack with a network
communication class switchable between asynchronous and synchronous.
When I use asynchronous udp communication I find that if I want to
process a large amount of dns lookups I have one dns provider with
many state objects passing through (and a high...
|
by: Emmanuel Charruau |
last post by:
Hi,
I am looking for a class or any information which would allow me to
make communicate mini-module in c++. I have been looking
on the net for some examples of such implementation, but I did not
find any good one. This is why I am asking here if some
of you know where to find some information on the internet about such
implementation.
|
by: mareal |
last post by:
I am using the System.Diagnostics.Process class in order to loop thru all the
processes running. Within that loop I am looking for the process name
“aspnet_wp” in order to get the process ID. Once I find it, I use the process
ID to find all the threads running under that process. This works fine so
far. What I would like to do is to be able to detect/find the threads that my
ASP.NET app. created.
I have tried giving the threads I...
|
by: dast |
last post by:
Hi,
I'm having trouble letting my background thread tell my main thread what to
do.
I'm trying to tell my main thread to open a form, but when my background
thread ends, the form that I thought my main thread had opened disappears.
Obviously there's something that I don't understand here.
The background thread is run in another class on another form. How do I,
| |
by: alen.petrol |
last post by:
Hi all
i got an asignment where is should simulate 1000 clients connecting to
a server via TCP, and each client has it's own sequence of data
exchanged so i have to have 1000 threads, so my bigest problem is how
can these threads communicate with each other something like this
Thread1 registers in the mailing system
Thread1 constantly monitores his mailbox
|
by: Roodie |
last post by:
Hello,
I have a quite specific problem, and after half a day spent with
Google, still no solid answer.
The task:
I have to write a C# class Library ( DLL ) to handle TCP socket
communication. It will be called by a multithreaded server application
to send some data to an another server ( which is a linux server ).
|
by: ne.seri |
last post by:
In short, I'm building a kind of server which is supposed to handle
open connections with clients. E.g. client connects to the server, the
connection stays open, client sends a request to the server, server
reasoned, and so on...
The thing is that connection MUST always stay open. I'm using C++, and
as for sockets, I'm using native syscalls, not MFC. I'm using stream
sockets for communication.
Another thing is that is should work both...
|
by: mastermagrath |
last post by:
Hi all,
I recently finished a small project using perl and tk/tcl which caused
me several headaches. I have now decided to have a go at VB .net and
thought a good place to start would be recreating the perl
application.
However, once again i'm running into similar headaches and wondered if
i could get a real developers opinion on how he/she would implement
it.
Basically the application is a small GUI wherein the user can enter an
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupr who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |