saseow
Posts: 744
|
| Posted: 09/29/2008, 4:55 AM |
|
I have a table which requires only one row per user i.e. user_id
A new user with no record in the table must be able to have an empty record in the editable grid to enter the data. Once entered and submitted, no empty row must be shown.
A user with data in the table will see only one row with his data that he can modify - extra rows.
Any idea on how to get this working?
Trevor
|
 |
 |
datadoit
|
| Posted: 09/29/2008, 7:41 AM |
|
Instead of trying to shove all of this logic into a single editable
grid, try putting a regular grid at the top, and just below it place a
record form (that lines up like an editable grid row if desired). The
data source for the record form would be the user's ID, and if the
record source is found they'll be in edit mode, if not they'll be in
insert mode.
|
|
|
 |
saseow
Posts: 744
|
| Posted: 09/30/2008, 12:40 PM |
|
Dadadoit,
Thank you! So simple and so elegant. Didn't need the grid element anyway but the record element achieves exactly what I want.
Kindest regards,
Trevor
|
 |
 |
|