Entering data once and having fill 2 fields

  • Thread starter Christina Thrun-Western Dairyland EOC
  • Start date
C

Christina Thrun-Western Dairyland EOC

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
 
J

JP

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"
 
Top