Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    tatuin
    Posts
    11

    Post Customer database model example

    Hello all,
    I'm searching for a good model for a customer database. I work for a place that has lots of customers, new and returning. Our internal application is Access with VB/VB scripting...and eventually we will be attaching it to a website for online ordering.

    I'm looking for a solid model, maybe with a history of success. Can anybody point me in the right direction?? An online resource or thread in another discussion group. Even if you have some good advice to give I'd appreciate it.

    of special note:
    In our scope meetings we defined a special situation where payers information can be defined in several scenarios:
    1) one event - many customers, multiple billing sources (e.g. school competition with independant teams)
    2) one business - multiple contacts, multiple billing sources (e.g. corporation with independent departments)
    3) one business - multiple contacts, one billing source (e.g. church)
    4) one customer - one contact, one billing source (e.g. individual)

    The shipping element can be just as convoluted.

    Thanks in advance for you help!
    H
    Last edited by hobojawa; 02-12-04 at 12:05.
    I never met an android I didn't like to take apart and sell as scrap

  2. #2
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710

  3. #3
    Join Date
    Feb 2004
    Location
    tatuin
    Posts
    11
    excellent. many many thanks.
    I never met an android I didn't like to take apart and sell as scrap

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •