Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Design Issue : prospects

    hi all

    help me if you can.

    Description :
    My current Access DB also have a customer Table that i keep track of customers who have bought something from us.

    We also invite prospects to our marketing events. Currently the prospects list are stored in Excel spreadsheets.

    Now i would like to keep the prospects in my Access table.

    Question:
    should i have a seperate Prospects table or integrated teh prospects list into my Customer table and have a status field to keep track whether it is a "CUSTOMER" or "PROSPECTS"?

    if i have a seperate Prospects and Customer table, what is the bets way to move the prospects records from the Prospects table to the Customer table when they bought something?

    Regards
    bryan

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171

    Re: Design Issue : prospects

    Sounds like you just want one table, then you won't need to move the records about. You could have views called CUSTOMER and PROSPECT to pull out just one or the other type when needed.

Posting Permissions

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