Re: Input info to 2 tables?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: AlCamp (anon_at_anon.net)
Date: 10/16/04 

Date: Sat, 16 Oct 2004 09:40:23 -0400

Tlaker,
   Your main form should be based on a table that contains the Customer
information, and your subform should be based on a table that contains your
Arrival Departure information. For example tblCampers and tblVisits.
   Each Customer in tblCampers will have a unique identifying number, (a key
field) and will be "related to" the tblVisits by that number. Ex. a
CamperID.

   This is a normal "one to many" relationship. One Camper, Many visits.

   Only Camper information is entered on the main form (one time only...
except for any occasional changes in that information), and after each new
visit, you'll just add another "visit" record to the multiple record subform
for that camper.

   Check out "one to many realationships" in Help, and read all about how to
set up your key field, and table fields.
hth
Al Camp

"Tlaker" <dpmcc@localnet.com> wrote in message
news:10n0krgfu6g006d@corp.supernews.com...
>I manage a campground and have decided to transfer my files from MS Works
> database to Access 2k. I have a flat database now with, among other
> fields,
> "Name", "Arrival" and "Departure" written to the table. I'd like to have
> these fields written to a subform, "History" that would show at a glance
> the
> dates of previous arrivals of each separate camper. Because my other
> workers are not computer literate, I need to make the input as simple as
> possible. Is there a way of entering data on the main form, replacing
> what
> was there with new information and at the same time having the same
> information added to a subform as a new record unique to "Name", keeping
> all
> the old information? Thanks for any help you can offer this newbie.
>
>

Quantcast