Can anyone suggest the best action to take for the following:

I have a main form, which has a table source called "radios". I would like to have a datasheet or subform at the bottom of the main form that list all the records in the source table. A one-to-many relationship does not exist, because I am using the same table in this datasheet as the form. The catch is - I would like the main form to load a selected record in the dataview. I am not concerned with the normal operation of form to subform requires.

Any help would be greatly appreciated.