Maintaining foreign key relationship between two servers

[Former Member]

Hi,

I am maintaining the Custom table in one server using SM30. Here i have to maintain the foreign key relationship with other table which lies in the some other server.

Is it possible to maintain the foreign key relation ship between two servers.

Expecting the reply from you soooon.

Thanks in Advance

Regards

[Former Member]

HI

GOOD

I DONT THINK YOU CAN CREATE THE FOREIGN KEY RELATIONSHIP BETWEEN TWO SERVERS.

THANKS

MRUTYUN

[Former Member]

Hi,

You can maintain the parent child relation ship between the tables with in the same database.

You cannot have a relation with a table in a different server. You can implement it manually though, by writing the code to check values.

Regards,

Ravi

Note : Please mark the helpful answers

[Former Member]

Hi rajasekhar,

1. Directly, using DATA Dictionary foreign-key relationships,

its not possible.

(Database does not allow such facility, so far)

2. I am maintaining the Custom table in one server using SM30

If this is the case, then

u can use events in SM30

so that while saving the record,

u can write your own code,

which will check the values in the REMOTE Server,

using some your own Z FM and using DESTINATION extension.

3. In this way, u can indirecty maintain

the foreing key relationship between two servers,

and two tables.

regards,

amit m.

[Former Member]

HI

GOOD

I DONT THINK YOU CAN CREATE THE FOREIGN KEY RELATIONSHIP BETWEEN TWO SERVERS.

THANKS

MRUTYUN