Subform linked to other subform and main form

  • Thread starter Thread starter Jinny
  • Start date Start date
J

Jinny

Hello,

I am looking for strategies to complete my form. I am not familiar with
complex coding.

I am creating a contact history database. My tables are setup and linked
appropriately. For forms, I have:
Main: company
sub: contacts within company
subsub: communication log

I would like the log form to be able to show communication history
associated with individual contacts when the contact is selected, as well as
show communication history associated overall with the company when no
contact is selected. The communication log table has a Company ID and
Contact ID that it connects to--all of the entries have a corresponding
Company ID, but not necessarily a Contact ID.

Is there a way to do this simply? The other solutions I have thought of are
to split the information into two tables, one with Contact ID, one without,
and then have one subform or another appear. I have experimented with
queries, but am unsure of how to make that happen.

Thank you!
 
I have decided to simply create general company contacts within the contacts
table. No need to respond to my question! Thank you.
 
Back
Top