Hi,
say I have two tables:
Table1:
Table1ID (primary)
...other fields...
Table2:
----------
Table2ID (primary key)
....other fields)
Table1ID <---I want to create a relation to Table1
What I want to do is when a record is deleted/updated in Table2 the corresponding record in Table1 is updated/deleted as well.
Now, in DM, I choose non-id relationship and drag from Table2 to table1. The relation that is created shows Parent --> Table2 and Child --> Table1, which is correct.
Then, the fields that are linked are Table2ID (the primary in table2) to either Table1ID or to a new Table2ID (in table1).
What I want to do is to link Table1ID from Table2 to Table1ID from table 1.
If I drag the relationship from Table1 to Table 2 I can play with the fields the way I describe but the cascade behaviour is not what I want.
How can I sort this out?
Thanks
John