Hi all,
Why in constructin relations basically in table extensions CustTable I can't select RecID, just DataAreaID, what it causes and how to solve it?
You can't have a relation between RecId and a string. You can only select related fields that have matching data type.
You must use Int64 data type (extended data type RefRecId) if you want to define a relation to RecId of another table.
String Type
What is the data type of the field that you try to use in the relation with RecId?
I am creating a relation of extension custTable with dbVehicleTable, when I searching relatedfield, select preferredVehicle of extension table, I can't found RecId just DataAreaId.
You can only select related fields that have matching data type.
What is the data type of the field that you try to use in the relation with RecId?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156