Re: Developper 2000 master/detail

<snipped>

[Quoted] The relation between the two tables
> is cycle and item.
>

This is the point: it prooves that Your data model in the database (ERM) is some sort of "strange" (like many others ...), it has no classical Foreign Key contruction, e.g.

Table1
(

   id primary key,
   ... other columns
)

Table2
(

   id primary key,
   Table2_Id [foreign key]
   ... other columns
)

Table1 is the Master of Table2, the FK is 1:N .

For M:N, the construction would be

Table1
(

   id primary key,
   ... other columns
)

Table2
(

   id primary key,
   ... other columns
)

T1T2_Combinations
(

    Table_Id1 [FK to Table1],
    Table_Id2 [FK to Table2]
)

T1T2_Combinations maps any combination of Table1 and Table2 data.

But what You describe is nothing like this, You seem *not* have any FK-relationship
defined. Instead, You have 2 matching columns - this is no FK. The result then
depends totally on the data.

This is no Forms issue. It is an ERM issue in the database (once more) !

So my suggestion would be, to check the actions that You expect from Forms, try the SQL in SQLPlus or some similar tool. Forms can only map what the SQL does.
So: check the data. When You have Your expected result in SQL, according to Your data,
then retry to map it in Forms.

hth, Jan Received on Mon May 17 2004 - 09:15:31 CEST