Using SOME data from another DB (2000/SR1)

Topic

New Reply

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.

Reply | Quote

Replies

Don,

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.

HTH,

Tom

Reply | Quote