create recordset from input value
Hi there - I have an items table and a decor table. There will be multiple items that use certain decor sheets. On my items_Insert.php page I have a field called ItemDecorID. If this is populated I want certain fields underneath it to be automatically populated from the decor table, so I will need to bind a recordset to the page containing the decor data WHERE DecorID = the value input into the ItemDecorID field. Can you tell me how to do this?