subform for phonecalls

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

Guest

I would like to create a subform linked to each customers in my main form,
that is based on a table, that will keep track of their phonecalls to my
company and our answers. Perferrable I could have a control button name
Phonecalls and when I click it I would get all the phonecalls from only one
customers. Any ideas ?
 
I would like to create a subform linked
to each customers in my main form,
that is based on a table, that will keep
track of their phonecalls to my
company and our answers. Perferrable
I could have a control button name
Phonecalls and when I click it I would
get all the phonecalls from only one
customers. Any ideas ?
Click to expand...

What kind of "ideas" are you seeking?

You will clearly need a Table for recording the information you want to save
about the phone calls. It will clearly need a unique key of its own, and a
foreign key to the customer record -- if you want, you could use a compound
key consisting of the foreign key to the customer plus a key identifying
this call for this customer.

You'll need a Form that displays a phone call, or a continuous forms view
Form that displays multiple phone calls. The Command Button wizard has an
option for Forms Operation | Open Form and later in the Wizard will let you
pick one Control on the same form as the Command Button to use to select the
records displayed. Alternatively, you could put the phonecalls Form in a
Subform Control and use the LinkMasterFields and LinkChildFields of the
Subform Control to coordinate the main (Customer) Form with the (Phonecalls)
Form embedded in the Subform Control.

If you have specific questions, or if this does not address your question,
post back here.

Larry Linson
Microsoft Access MVP
 
Back
Top