Also, I wouldn't even bother with putting up a table of driving
instructions. I'd hook into Google's map driving capabilities. Don't
reinvent the wheel unless you absolutely have to.
On 11/17/2013 2:20 PM, James E Lang wrote:
I have no experience designing a database. I hope this list is a satisfactory
forum for my questions.
My son delivers a variety of newspapers with some subscribers getting more than
one publication and with each publication's deliveries varied according to the
day of the week.
I want to construct a database that will permit me to use eMail to send him a
PDF file for a day's delivery list including instructions for driving the
route. On a bad day I must be able to quickly apply as many as ~25 of these
subscriber changes to the database:
• new subscription starts
• old subscription stops and restarts
• add/alter special delivery directives
I also need the ability later to resequence one or more subscriptions relative
to the detailed driving instructions and to alter those driving instructions.
How much of this can be done using Base? What are the "gotchas" and design
requirements? I expect that I will need a table of driving instructions, a table of
publication delivery schedules, and a table of subscriptions with some kind of hooks
interconnecting them.
I'm perfectly willing to take any discussion this may start off list after the
initial round of responses if requested to do so with the understanding that
I'll report back my final conclusions.
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
