Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Modifying Wizard search parameters and detail page links for products that have more than one product type

View all replies to this thread

Modifying Wizard search parameters and detail page links for products that have more than one product type

Thread began 11/21/2016 12:37 pm by tmcbinc99963 | Last modified 11/22/2016 2:50 pm by tmcbinc99963 | 1629 views | 8 replies

11/22/2016 1:01 pmtmcbinc99963

Product number 252 has an ID of 26 in the 'prod' Db. This ID is used as a foreign key in the 'prodtype' table (column ProdIDType).

The product types originate in the 'lubetype' table as LubeTypeID 4 (torque) and 9 (tractor). These are used as foreign keys in the 'prodtype' table (column LubeID).

The primary key in the 'prodtype' table (column ProdTypeID) for each is 29 and 30

I've tried using the 'prodtype' table, both as a data source in the WADAProd recordset and in updating the Wizard parameters. Neither provided the desired result.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.