Hi all,

I have been racking my brain all day today <img src=../images/dmxzone/forum/icon_smile_dead.gif border=0 align=middle> trying to think about inserting a new record into my database. Here goes the problem:

I have a database which is a business directory database. I have a couple of tables in there connected through relationships. I have a category table with the category name and category id as the fields. This table is connected to a business table which has all of the business info in it. They are connected through the category id. I want to add an insert page but need it to go into the correct category. If I create a recordset with the category table, I only have the id and name to insert. If I create a recordset with business I only have an id for the category. I want to be able to first view all of the categories, then select the category I want to add a new record to and click on the category to go to an insert page.

Can this be done?

Thanks for any help,

Adam Toohey