gget79
26th September 2008, 18:30
Hi experts,

I am working with Infor LN 6.1

I have a big problem with the references to parents table.

For example:

My parent table is ticpe001,
I am filling with information in this table
ticpe001 is indexed in ticpe002
I am filling information in ticpe002 using ticpe001 information
I try to delete the parent data in ticpe001 and I don't get any error and LN permit me delete this row.

I am using in ticpe002 child field the following
Reference Table ticpe001.field
Reference mode: Mandatory unless empty
Reference message: ticpe.error

x Check bu DBMS
Delete mode: Lookup (Restricted)
Update mode: No check


Somebody can help me?

I need that LN don't permit me delete a row in the parent table if I have a references used in other table

NPRao
26th September 2008, 20:07
Did you create runtimes for the table & restart the shared memory?

Also, refer to the thread - Deleting table references... (http://www.baanboard.com/baanboard/showthread.php?t=53121&highlight=restricted)