SELECT StoreCategories.CategoryID AS ViewField1, StoreCategories.CategoryName AS ViewField2, StoreCategories.CategoryDesc AS ViewField3, StoreCategories.CategoryID AS ID_Field
FROM StoreCategories
WHERE StoreCategories.CategoryID = #URL.RecordID#
Control - View Record
Control
View Record
| CategoryID: |
#ViewField1# |
| CategoryName: |
#ViewField2# |
| CategoryDesc: |
#ViewField3# |