SELECT StoreManufacturers.ManufacturerID AS ViewField1, StoreManufacturers.Name AS ViewField2, StoreManufacturers.ManufacturerID AS ID_Field
FROM StoreManufacturers
WHERE StoreManufacturers.ManufacturerID = #URL.RecordID#
control2 - View Record
control2
View Record
| ManufacturerID: |
#ViewField1# |
| Name: |
#ViewField2# |