Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Aug 2001
    Anaheim, California, USA
    Thanked 2 Times in 2 Posts

    Using SOME data from another DB (2000/SR1)

    I have a database of names, addresses and other personal information, that I use daily. Call it Names. We have a one time event coming up and about 75% of the attendees will come from this database. Other people that sign up, do not need to be added to Names. What I want to do is set up a seperate DB, Event, to track registration for the event. This is probably simple but I'm not getting it.

    How do I pull in information from Names for those that sign up, while being able to add new people, that weren't a part of the original? The information from Names, comes from several different tables, Family, Parents, Students, Grades. Do I import these tables or Link them?

    I hope this makes sense. If there are posts out there dealing with this already, maybe somebody could point me in the right direction, I wasn't sure what to search for. Thanks for any help.

  2. #2
    Star Lounger
    Join Date
    Aug 2001
    Seattle, Washington, USA
    Thanked 0 Times in 0 Posts

    Re: Using SOME data from another DB (2000/SR1)


    While you could work up a sophisticated database to pull only the records (from Names) you need for the one-time event, it may not be worth your time and effort.

    The simplest thing to do is to create a new database (TheEvent.mdb), and import the appropriate tables, forms reports, etc., from the Names database. Next, add a (Yes/No) field to the table to indicate who will be attending the event.

    When you get positive responses for people already in TheEvent.mdb, make them a "yes" in the field.

    When you get positive responses from people not in Names, add them to the database, and make them a "yes" in the field.

    If you need to keep track of who was in Names, you could add a second (Yes/No) field. People who were in Names would be given a "yes" in this other field.



Posting Permissions

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