Open a table from within existing table

[mlswyo]

Is it possible to have a field in a table that when selected opens a different table? Might I be able to hyperlink to a table from within an existing table?

I'm want a table to list the names of all the lookup tables in my database then by simply clicking on the designated field the named lookup table opens for editing data in it. Any good ideas for doing this are welcomed.

thanks,
mlswyo

 

[spikepl]

Tables are not meant for user interaction. Forms are.

Make a form based on your table, and on the DoubleClick-event of the control bound to the desired columnn, open a new form based on the table you want to edit.