Access form is connected to a subform just fine. I would like to connect the subform to other information in a different table. The connection is at the subform level not the form level.
I have a form and a subform that work great. I would like a record on my subform to call another record that is connected by a linenumber id.
Can I do something on the subform so my users will know there is data tied to the record? There could be many records that have no information and I don't want to have to have them click on it just to check.
If it does have information on the other table I would like to click on a tab to show the information related to that record.