Entering data once and having fill 2 fields

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

Guest

I am designing a form in which to input information for a major event. Ihave
1 table: ConfEventIntake which is used for any event or training we may have
and collects name, address, demographic info, etc... It's primary key is a
unique client number that we assign. This number is what links multiple
tables together in which we track trainings, counselings, etc... One table:
2005WBRF is created specifically for our event. It contains the ClientNumber
as the primary key (same as the others). However, I am creating a form with
subforms to input all of this information (client address and demographics
and also what they are registering for (payment info is in this table as
well) ). However, I would like to only enter the client number once and have
it fill into both the ConfEventIntake table and the 2005WBRF table rather
than have 2 separate fields. Also, some of attendees will already have a
Client Number and will have a record in the ConfEventIntake so I will need to
be able to search by the client number and pull up the record but also create
a record for the same person in the 2005WBRF. Any help would be greatly
appreciated becasue right now I am setting up the form so that the
ClientNumber gets entered for each form and subform.
Thanks
Christina Thrun
 
If you link the subforms to the main form by the client number (link
parent/link child in the properties for the subform control on the main
form), then any record created in a subform will have the client number that
is showing on the main form.

There are a number of examples of this in the Northwinds database, and most
every Access DEVELOPERS textbook (e.g., WROX, SAMS, Sybex, Microsoft) will
show you how to do that. Make sure it's a book on Access Development (as
opposed to those that teach the basics of how to build tables and queries).



"Christina Thrun-Western Dairyland EOC"
 
Back
Top