How to autofill a field with data from another table

  • Thread starter Thread starter voice903fm
  • Start date Start date
V

voice903fm

I'm new to ACCESS 2000. I need a database file that will allow me to take
reservations from my clients and have some of the fields automactly fill in
data that is stored in another table.

Example: I have a field in my RESERVATIONS table name Package that list all
of the possible packages available. This data is stored in the PACKAGE table
along with the prices of the various packages. Once I select the package, I
want the field name Rate in the RESERVATIONS table to be filled in automatcly
with the correct rate that correspond with the selected package.

Can someone tell me how to do this.
 
I'd recommend that you use forms to do this, rather than working directly in
the tables. Access tables store data ... and that's about it!

Access forms give you a way to add/edit data, and to select a Package (via a
combo box) and save the Package's (?current?) rate.

By the way, if your PACKAGE table holds the rate information, you may not
need to duplicate that data in your RESERVATIONS table. After all, a simple
query that joins RESERVATIONS and PACKAGE with allow you to determine the
rate associated with the package.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
(should have read "... and PACKAGE will allow you ...")

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top