SELECT forklifts.equipID,
forklifts.manufacturer AS thisManufacturer,
forklifts.model,
forklifts.serial,
forkliftManufacturers.manufacturer
FROM forklifts,forkliftManufacturers
WHERE forklifts.equipID = #url.product#
AND forklifts.manufacturer = forkliftManufacturers.manufacturerID
SELECT other.equipID,
other.manufacturer AS thisManufacturer,
other.model,
other.serial,
otherManufacturers.manufacturer
FROM other,otherManufacturers
WHERE other.equipID = #url.product#
AND other.manufacturer = otherManufacturers.manufacturerID
-------The Following is a Used Equipment Quote Request from the Hy-Tek Website-------
--- Requestor's Information ---
Company: #form.frmCompany#
Name: #form.frmName#
Phone: #form.frmPhone#
Fax: #form.frmFax#
Email: #form.frmEmail#
Address: #form.frmAddress1#
Address 2: #form.frmAddress2#
City: #form.frmCity#
State: #form.frmState#
Zip: #form.frmZip#
-------------------------------
--- Equipment Information ---
Manufacturer: #qryProduct.manufacturer#
Model: #qryProduct.model#
Serial ##: #qryProduct.serial#
Looking to make a decision in: #form.frmDecision#
---
Additional Accessories Needed:
#form.frmComments#
spam
Hy-Tek / Innovative Material Handling Solutions
