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