A
Andreas
Guest
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
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