Alpha Video Training
Results 1 to 3 of 3

Thread: Do I make a new table?

  1. #1
    Elsie Beall

    Default Do I make a new table?

    Hi there.

    I'm building a database for someone that will contain customer and billing info. They have previously been using books to keep track of their info, and once the DB is complete, will want to enter all of their archives as well.

    Should I create a separate form to enter the archived info that is tied to a separate table? Perhaps new tables for each archived year.

    I've never used sets yet. Is that going to be a big project? If I use new tables for the archive info, I would still like to be able to use all of my current forms, reports and queries to manipulate the data.

    Am I biting off more than I can chew here? The A5 manual is great for giving me really good definitions of the functions and I think in theory this can be done exactly the way I want it, but I'm having a really hard time with the syntax of my expressions etc.

    Any help is most appreciated! Thanks!

  2. #2
    VAR Pat Bremkamp's Avatar
    Real Name
    Pat Bremkamp
    Join Date
    Apr 2000
    Oregon, USA

    Default RE: Do I make a new table?

    I don't think you are biting off more than you can chew because you are asking all the right questions up front.

    If I was going to do this, I would put a "Fiscal year" field in the table and whenever I needed particular info, I could use a filtered index or a query to find the year data. If you use separate tables for each year, your user will have to do a lot of setting up at each year end and it will make your job harder.

  3. #3
    Elsie Beall

    Default RE: Do I make a new table?

    Thanks for the help.

    Sometimes the easiest answer is the one you pass over just because it seems too easy!!

Similar Threads

  1. Make new friends
    By Edward Larrabee in forum Alpha Five Version 6
    Replies: 0
    Last Post: 01-14-2005, 05:16 AM
  2. Won't make new record...
    By dik_coleman in forum Alpha Five Version 6
    Replies: 4
    Last Post: 12-20-2004, 06:26 AM
  3. How do I make my own application
    By jeresmall in forum Alpha Five Version 5
    Replies: 4
    Last Post: 06-04-2004, 02:44 PM
  4. How to make a report
    By Fred M. Pfeiffer in forum Alpha Five Version 5
    Replies: 4
    Last Post: 11-23-2003, 03:51 PM
  5. How do I make user select from table?
    By Graham Wickens in forum Alpha Five Version 4
    Replies: 6
    Last Post: 11-05-2000, 10:45 AM


Posting Permissions

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