using insert record wizard with multiple recordsets

[Angelic_friends15D5]

I am trying to create a way for a client to insert records into their database using the record insert wizard. I would like them to be able to choose categories which are in separate tables. To get a pull down menu showing only the records in the given table, should i use a second recordset to get the values, and the original recordset to set up the main table information? Any help is appreciated. Thanks.

[Newsgroup_User]

>I am trying to create a way for a client to insert records into their
>database
> using the record insert wizard. I would like them to be able to choose
> categories which are in separate tables. To get a pull down menu showing
> only
> the records in the given table, should i use a second recordset to get the
> values, and the original recordset to set up the main table information?
> Any
> help is appreciated. Thanks.



Yes.