[Lord_Zeus]

I can not make related table. I have this situation: have an idea, which is the usual field:

"product" -> "schet" (data like "62/001/001/005") and I want to connect it to another table "card_tk" -> "produkt_cod." Display I need "product" -> "short_name".

 

How can i solv this problem. If im write this in SQL it seems to be like this: 

select `product`.`short_name`
from product, card_tk
where
product.`schet` =  `card_tk`.`product_cod` and
`card_tk`.`kod` = 2; 

it for examlpe...im need to see in "selector" fild `product`.`short_name`, and connection finds most be on product.`schet` = `card_tk`.`product_cod`. In result of opiratin programm most update a table `card_tk`->`product_cod`

 

I'm realy dont know how to do this....

 

[Amit Shah]

well my friend-if this is going to be a complex query - i will suggest you to have it done 2 ways -

1 - change field_type of the field to array ... and dynamically create an array of values u want to present it to user and set it to the field... (much simpler to go with)

2 - Create a model and set out your own custom query

 

Both should surely work for you.

 

Happy GCing :)