"Create" button in relations dialog

[Anne Verrinder]

Hi all,

When using the "create" button in the relations dialog, if the backend database (in this case, MSSQL Server) contains more than one relation between any two tables, the "create" function only discovers one of these.

Is that expected? If so, how does it decide which to "create" in the app? Is there any way to get the rest of them in? I'm guessing we could recreate them in the app (solution), but we have hundreds ...

Thanks

Anne

[jcompagner]

what are the versions that you use for youre database and its driver?

[Anne Verrinder]

Hi ...
SQL Server 2000 (8.00.534 in "about enterprise manager")

Driver: Microsoft SQL Server 2000 Driver for JDBC, Service Pack 2, Version 2.2.0037, August 2003

Thanks,

Anne