New form or Subform???

[Guest]

I am new to access and am teaching myself as i go along. This is what I want
to do:

I have a table of Entertainers. I have another table listing show dates and
entertainers booked. What i want is to have a form to choose the show date,
pick the entertainer(s) (up to 20 max) to book for the show and i guess a
subform so i can enter the 5 song choices they give for that paticular show.

Is a subform what i would use and if so, how do i get it so when i select
Ent1 from the drop down list, it puts that persons name in the subform where
i will enter their song choices.

Thanks in advance for your help!!!

 

[Guest]

Hi

If you create a new (sub) form then all your need to do is the link the main
and sub by ensure that there is a common field in both (normally the ID or
autonumber).

To do this open the main form i design view and click the tool box - insert
subform.

You will have have choice of available fields (fields on both forms) that
you use to link.

I suggest using the ID field as it is less likely to mess up.

Then when you select a performer from a combo in your main form the subform
will be "linked" to that performer.

Good luck hope this helpful