Create Record

[Zanstemic]

I'm currently opening a form to do data entry. The data entry is in two
tables with records that relate.

The tables are Attendee and Registration. On opening the Data Entry I would
like to have the Registration Table have a record created that has a
relationship to Attendee. This way I can have a query that relies on records
in both tables.

Any suggestions and detail is appreciated.

 

[Klatuu]

This is a usual Form/Subform situation.
If the Registration table is the parent to the attendee as it should be,
then the registration table should be the record source for the main form.
Make the attendee table the subform's record source.

 

[Zanstemic]

The Attendee is the parent and they can have multiple entries listed as
events. This makes the Attendee the record source and the Registration is the
subform.

What is the best approach to setting up th subform? (ie. form view, event
procedure on open, etc.) The intention is to have a default entry with a
status field defaulted. The user than can select the type field in the
subform.

 

[Klatuu]

If I understand correctly, I think you should use the Default Value property
of the control to set the value of the Status.