Valentina Digest, Vol 22, Issue 17

[Thomas]

>>> The following Base Object Method is causing trouble in VAPP.
>>>
>>> if(ptr_parent_rcd = ptr_child_rcd,'False',if(ptr_parent_rcd
>>> ptr_child_rcd,concat(ptr_parent_rcd,'-
>>> ',ptr_child_rcd),concat(ptr_child_rcd,'-',ptr_parent_rcd)))
>> The "On delete" property for both the parent and child ObjectPtrs in
>> the lookup table is set to "Cascade". So the ObjectPtrs are deleted
>> when the RecIDs they point to are deleted, no? Does this not prevent
>> re-use mistakes? Is there a better way to manage these comparisons?
>
> But you compare RecIds !
>
> Why ?
>
> Explain your idea please
>
> You think that PARENT always have less RecID then child ?

A little hard to explain. Maybe this will help.

Fact Table_______________________
Fct_Tbl_RecID		Fct_Tbl.Data_Field		
	10				Thomas
	20				Mary
	30				Jane
	40				Lena
	50				Lily

Lookup Table_(2 Ptrs to 1 Fact_Table)__
Ptr_Parent_Rcd	Ptr_Child_Rcd
	10				20
	10				30
	40				30

Recursive many to many on the one Fact table. Any fact record can be 
related to any other fact record. Lookup table tells which records are 
related (linked) to which other records.
Thomas is related to Mary and Jane. Lena is related to Jane.
Lookup table records have to be unique. We have Thomas related to Mary 
(Lookup_Table first record 10 to 20). We don't need, and so try to 
prevent, Mary related to Thomas (20 to 10).
Base Object Method won't allow import of new Lookup_Table records. 
Would like to import 50 to 40, 50 to 10, etc. But Base Object Method 
thinks these are not unique.

Hope that helps, and thanks again.