>I am attempting to create a cursor, using my database's .dbc table, that will match all Field
>objectnames with its corresponding Table objectname. I know this is done somehow by pairing the Field
>object's ParentId with its matching Table ObjectId, but how, I'm not sure. Thanks.
Is this what you're looking for?
SELECT ttField.ObjectId, ttField.ParentId, ttTable.ObjectName as TableName, ;
ttField.ObjectName AS FieldName ;
FROM tastrade.dbc ttTable ;
JOIN tastrade.dbc ttField ON ttField.ParentId = ttTable.ObjectId ;
WHERE ttTable.objecttype = "Table" ;
AND ttField.ObjectType = "Field" ;
ORDER BY tableName, fieldName