I need to create an administrative page to update a table and make it as simple for the end users as possible but I am having a terrible time figuring out how to do it. Here is the situation... I need to allow the end user to update which products are carried by which warehouses. Both products and warehouses are stored in their respective tables with a table used to associate one with another. The MS Access tables are as follows: wtbProducts table contains fields productID and Alias (the name of product) wtbWarehouses table contains fields WarehouseID and Alias (the name of the warehouse) wtbProductWarehouses table contains fields productID and warehouseID I have a page set up so that the user can select a specific warehouse and the warehouseID will be passed as a querystring to the second page. On this second page I want all of the products displayed with checkboxes. If the productID/warehouseID combination is found in the wtbProductWarehouses table I want the check box to be checked. Odviously then the user will check/uncheck which products are shipped to which warehouses so I will then need to update the wtbProductWarehouses table accordingly. This process is absoultly killing me. If anyone can help me out I would greatly appriciate it. Thanks!
you going to have to help us out a little bit providing more information. so I will give you a starting point 1. construct a recordset that will retrieve all the products 2. construct another recordset that will retrieve all the products for a specific warehouse. 3.loop through the first recordset and for each product dynamically create a checkbox, within this loop, loop through the second recordset looking for this product to see if it exists, if it does set the checked property/value to on.