Filter datasheet via combo box selection

[vector39]

Hey guys so I was thinking...So this is what the form is for the user, a datasheet in split form



As you can see this is all agency info but I was thinking of adding a button right beside subsidiary that would open up a form and display that specific (e.g. SandStone United) subsidiary's information, e.g. address, email, contact info, etc. Does a relationship still need to between tblAgencyInformation and tblSubsidiaryInformation still need to exist?

[orange]

I suggest you add the button and try it. Make a backup of what you have first---just in case.

Good luck.

[vector39]

Thanks guys. I think we're good now.