Opening one table from another

[jiminy]

I have a primary table (for data)and an auxilliary table (for comments) Aux. doesn't have comments for every record, only when Primary has a 'y' in its comments? field.
When entering data, is there a way to trigger Aux. to open for edit by entering the 'y' into the Primary comments field?
I would rather not use forms, buttons etc, but have no idea how to associate the code with the tables or where to put it. Are forms the only way?
I may have further questions if the answer to this one will at least get me started.

 

[Guest_imported]

Code can't be attached to a tableview so there is no way I know to do what you want without having a form, library or script in control of the tableview. I think it would be easier to use a form to enter the data and have the two tables linked in the data model.