TableRelation

bjorn

Hi
Can i get a fields table relation as a String?
I'm running Navsion 3.7

Example. Get field "No."s table relation in sales line
str := field....
MESSAGE(str);

IF (Type=CONST(" ")) "Standard Text" ELSE IF (Type=CONST(G/L Account)) "G/L Account" ELSE IF (Type=CONST(Item)) Item ELSE IF (Type=CONST(Resource)) Resource ELSE IF (Type=CONST(Fixed Asset)) "Fixed Asset" ELSE IF (Type=CONST("Charge (Item)")) "Item Charge"

ara3n

for simple table relationships you can get the relationship from the field table. The fields are RelationTableNo and RelationFieldNo. For complex ones. I would export the objects as text and find the property.

I know it suxs doing it this way, but oh well.