Question
October 15, 2007 at 06:47 AM
subscriptions

MS Access. 2 subforms from same table.

by subscriptions . Updated 19 years ago

I have a form called “customer issues”, which is a single form view. Inside of this I have a subform called “communications”, which is a datasheet view.

This works by each “customer issue” having multiple “communications”.

The “communications” table has Date, Time, Subject,Notes. As the notes could be long I want to insert a second subform which only have the ‘notes’ field in it.
When I click on a communication in the first subform it will automaticaly show me only the notes relating to that paticular comunication.

This discussion is locked

All Comments