foreign key support

[Andreas]

hi,

I'm trying to use the foreign key feature of dadabik, but I can't get it to work proberly.

main table: table1

id(*) supplier_id
------------------------
1 2
2 0
3 1



other table: table2

id_num (*) name
--------------------------
0 ABC
1 DEF
2 GHI


(*) is a primary key.

supplier_id is the foreign key in table1. In the internal_table_manager I have supplier_id declared as a select_single field, that should get its data from the table2.name. In the foreign_key_field I entered table2.name.
Now I can select the values from table2 in the dropdown box for supplier_id, but when viewing the table, I can only see the value of table1.supplier_id and not from table2.name.

So, what am I doing wrong here?


Greetings,

Andreas

 

[Andreas]

is nobody able to help me, or did nobdoy understand what I mean?


-Andreas

 

[Andreas]

hmm, it seems like I'm monologizing here...

ok, now I figured out how this foreign key thing works.
It actually *copies* the values from the other table to the main table, which is not a good thing.

Normally you have a main table, with a foreign key which points to a primary key from another table, where a values are stored.

Is this type of foreign key support sometime available in dadabik?


Greetings,

Andreas

 

[Eugenio]

Andreas wrote:
>
>
> hmm, it seems like I'm monologizing here...
>
> ok, now I figured out how this foreign key thing works.
> It actually *copies* the values from the other table to the
> main table, which is not a good thing.
>
> Normally you have a main table, with a foreign key which
> points to a primary key from another table, where a values
> are stored.
>
> Is this type of foreign key support sometime available in
> dadabik?

The foreign key support in DaDaBIK doesn't copy anything, it simply give you the possibility to choose your option from another table.

Is it clear?

(Latest version of DaDaBIK when this message was posted: 1.8)