Markie
Posts: 251
|
| Posted: 12/03/2008, 7:05 AM |
|
I have an editable grid with a listbox:
Name: Album
Control source type: DBColumn
Control source: album
Connection: Connection1
Data Source Type: Table/view
Data source: albums
Bound Column: album
Text Column: albumname
etc.
When using this listbox, the "album" value is add to the database table.
However, I also want to have the Text column ("albumname") added to my database table.
Is this possible ? Can I have both values (Bound Column and Text Column) in two different fields of my database table ?
_________________
The Netherlands, GMT+1
Tools: CCS 5.1, Windows 7, Navicat, Ultraedit
Local server: XAMPP with Apache, php and MySQL
Webserver: Windows 2008 IIS 7, php and MySQL |
 |
 |
Gena
Posts: 591
|
| Posted: 12/03/2008, 11:19 AM |
|
Not sure I understand Why you need to put BOTH value? You can easy show any related value using VQB (JOIN statment)...
btw if you really need to put both value you need to add that field as hidden somewhere at the end of Form, then in event like BeforeInsert/BeforeUpdate get its value using related Table, then assign it value to hidden field like:
$Component->datamodifica->SetValue(date("Y-m-d"));
_________________
Gena |
|
|
|
|
