Automatic Data Entry into Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a table for special event bookings with separate fields
showing name of client, address, phone, date of booking, and other pertinent
information. We have several repeat clients, and, rather than having to
re-enter this same information over and over, I would like to be able to have
the entire row of fields automatically fill with information. I'm brand new
to Access--could you please explain how I would go about setting this
operation up? Thanks!
 
Well, thae whole point of a relational database is to store related data in
different tables and link the data.

You need to step back and think about your table design. Your current setup
is nothing more than a spreadsheet.

For starters, you would want a table with customer data. It should contain
a customer code or number that you can use when you want to refer to that
customer. You'd enter their data one time in this table and then never have
to enter it again.

Your other tables, such as your event booking table, would have a field
where you would enter the customer number and the other pertinent data such
as date, type of event, etc.

When you run a report, view the records in a form, or pull the data into a
query, you would include both tables in your data source. Then, you could
pull the event date from the detail table, and the customer name and address
from the customer table.

Look at the sample databses that come with Access to figure out more about
relational setup. You might even use the built-in 'event manager' database.
I would bet it will do ten times more than your current database and you can
modify to meet any of your needs that it is lacking.

Rick B
 
Rick, thanks a bunch. I can see what you mean about having a simple
spreadsheet--am only beginning to see how this program can work for me! Will
spend a bit more time re-thinking the set up I have. Thanks very much!
Janice
 
Back
Top