The main form (frmPoduct) has primary field - ProductID (text) , ProductCategory(text) and more…
The main form displays one record at a time
The sub form show all the records with the same ProductCategory as in the current record in the main form.
Can I make it links in the opposite direction : when I select specific record in the sub form I need this record become the current record in the main form ?
Thanks in advance