"jason" <jason@catamaranco.com> wrote in message
news:#0bGOxObDHA.2336@TK2MSFTNGP09.phx.gbl...
> I could sure use some conceptualization and query help with a Page Watch
> System I am building in Access 2000 and Asp.
>
> I need to cycle through databae and generate a compiliation query email
that
> notifies a person of yacht(s) that have changed on our website:
>
>
> Key database tables
> --------------------------------------------------------------------------
--
> Customer (1) --->> (many) Customer_Boats (many)<<---- Boat (1)
> --------------------------------------------------------------------------
--
>
> Person A is watching: Boat1, Boat 2, Boat 3
>
> Person B is watching: Boat3, Boat 4
>
> Person C is watching: Boat 1, Boat 2, Boat 3, Boat 4
>
> Thus:
>
> Boat 1 has the following persons: A C
> Boat 2 has the the following persons: A, C
> Boat 3 has the following persons: A B C
> Boat 4 has the following persons: B, C
>
>
>
> Thus:
>
> My dynamic page has to compile a report for each customer based on the
boats
> he is watching:
>
> eg:
> LOOP
> sToAddress = sTo
> Page Notification for Person" & firstName
>
> Boat 1 price has changed:
> Original price: " & varOriginalPrice
> Reduced to:" & varNewPrice
>
> Boat 2 location has changed:
> Old location: " & varOldLocation:
> New Location: & varNewLocation
>
> END LOOP
>
> BUT
>
> I have to do this for all my customers at the same time and then send out
> the emails one after the other in a batch.
>
> I am completely lost on how to assemble this email report based on the
> overlapping selections of the user.
>
> I could just pull out a boat and send changes to people watching that boat
> but then a person may bet 50 emails in one day if he is watching 50 boats.
>
> I have to assemble all his choices dynamically in one email via some magic
> queries.
>
> Is this harder or easier than I am making out!
>
> Really, really appreciate some help here.
>
> - Jason
>
>
>
>

"Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
news:uZoHhMPbDHA.2404@TK2MSFTNGP10.phx.gbl...
> You've given a long description but which part of that specifically is the
> issue? Generating the SQL query?
>
> --
> ----------------------------------------------------------
> Curt Christianson (Software_AT_Darkfalz.Com)
> Owner/Lead Designer, DF-Software
> http://www.Darkfalz.com
> ---------------------------------------------------------
> ..Offering free scripts & code snippits for everyone...
> ---------------------------------------------------------
>
>
> "jason" <jason@catamaranco.com> wrote in message
> news:#0bGOxObDHA.2336@TK2MSFTNGP09.phx.gbl...
> > I could sure use some conceptualization and query help with a Page Watch
> > System I am building in Access 2000 and Asp.
> >
> > I need to cycle through databae and generate a compiliation query email
> that
> > notifies a person of yacht(s) that have changed on our website:
> >
> >
> > Key database tables
>
> --------------------------------------------------------------------------
> --
> > Customer (1) --->> (many) Customer_Boats (many)<<---- Boat (1)
>
> --------------------------------------------------------------------------
> --
> >
> > Person A is watching: Boat1, Boat 2, Boat 3
> >
> > Person B is watching: Boat3, Boat 4
> >
> > Person C is watching: Boat 1, Boat 2, Boat 3, Boat 4
> >
> > Thus:
> >
> > Boat 1 has the following persons: A C
> > Boat 2 has the the following persons: A, C
> > Boat 3 has the following persons: A B C
> > Boat 4 has the following persons: B, C
> >
> >
> >
> > Thus:
> >
> > My dynamic page has to compile a report for each customer based on the
> boats
> > he is watching:
> >
> > eg:
> > LOOP
> > sToAddress = sTo
> > Page Notification for Person" & firstName
> >
> > Boat 1 price has changed:
> > Original price: " & varOriginalPrice
> > Reduced to:" & varNewPrice
> >
> > Boat 2 location has changed:
> > Old location: " & varOldLocation:
> > New Location: & varNewLocation
> >
> > END LOOP
> >
> > BUT
> >
> > I have to do this for all my customers at the same time and then send
out
> > the emails one after the other in a batch.
> >
> > I am completely lost on how to assemble this email report based on the
> > overlapping selections of the user.
> >
> > I could just pull out a boat and send changes to people watching that
boat
> > but then a person may bet 50 emails in one day if he is watching 50
boats.
> >
> > I have to assemble all his choices dynamically in one email via some
magic
> > queries.
> >
> > Is this harder or easier than I am making out!
> >
> > Really, really appreciate some help here.
> >
> > - Jason
> >
> >
> >
> >
>
>