Master Detail Master not possible

rbuser

I have written a DADE component for TurboDB which is a german database
component for Delphi. All the tables, fields and relationships are filled
into temporary tables. In Designer I can select tables and see the
relationships.

There are some relationship tables in my database model (2 Masters / 1
Detail)...

Table1 (Master)
Table1_PrimaryKey

Table2 (Master)
Table2_PrimaryKey

Table_Relator
Table1_PrimaryKey \ Unique index over both fields
Table2_PrimaryKey /

I'm not able to build the second relationship, neither manually nor by
database. When I try to drag the second relationship (Table_Relator to
Table2), the first relationship disappears (Table_Relator to Table1). Do I
have to set any properties in DADE modul?

Kind regards, Michael K?nzi

nardmoseley

Sorry, but I do not understand what you are asking.

- are you using the RB DataDictionary to define the tables, fields, and
relationships? If so do you have AllowManualJoins set to true?

- The Query Designer allows more complex SQL to be defined than the Query
Wizard. I cannot determine from your description which you are using. Try
the Query Designer if you have not done so already.

If you still have issue, perhaps you can describe the issue within the
context of the RBuilder\Demos\EndUser\AutoJoins example.


--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com