To adjust foreign fields in Add/Edit mode

Talk about foreign keys

Moderators: ne_moj, zewa, vadimako, ne_moj, zewa, vadimako

Mister
Senior
Senior
Posts: 33
Joined: Dec 8th, '10, 10:05
Location: Ukraine(eastern part of Europe :D ), Kharkiv
Contact:

To adjust foreign fields in Add/Edit mode

Postby Mister » Feb 28th, '11, 13:58

I can't find how to save changes of foreign fields in add mode. It is says that [nativecode=1054 ** Unknown column 'name' in 'field list']
The sql is like ("SELECT c.id,d.name FROM car as c INNER JOIN driver as d on c.id=d.car_id")
I want even to save value of textbox to foreign field distinct of that, that is defined in Add/Edit/Details Mode Settings
In general I want to add/edit data in a few different tables in one time



Return to “Field type: "foreign key"”