DeSaedeleer
Posts: 8
|
| Posted: 02/25/2008, 3:26 AM |
|
I have an application with 3 tables:
- Employees with ID_Persoon as primary key
- Telephone (table name: TelefoonAdres) with persoon_id as primary key and a field with the telephonenumber
- Projects with persoon_id as primary key and a field a project name.
There is one page with a search section. I give part of a name and get a grid with the employee names and id (id_persoon). Clicking on the id_persoon gives me 2 editable grids: one where I can add telephone numbers and another for projects.
In thes 2 grids, the persoon_idfields are hidden and should get the value of the clicked id_persoon. As shown in one of your examples, there is a "BeforeBuildInsert custum code" where the value of persoon_id should be filled automatically. This is the code:
If not isEmpty(request.QueryString("id_persoon")) Then
TelefoonAdres.datasource.persoon_id.value = request.QueryString("id_persoon")
End If
This works fine frore the table TelefoonAdres but not for the table Projects (the BeforeBuildInsert is the same as the code as above, with TelefoonAdres. datasource replaced by Project.datasource.
The 2 grids are on the same page. Why is the value of Id_persoon passed to persoon_id for the table TelefoonAdres and not fot the table Projects ?
How can I fix this?
Kind regards,
Guy
|
 |
 |
|
