Nielsen
Posts: 2
|
| Posted: 11/03/2004, 8:56 AM |
|
I am attempting to set up an editable grid that will allow the viewing of previous records without allowing update or delete just insert. The user should be able to see previously entered records, but only be able to add new records not change existing records. I have discovered if I turn off update and delete the previous records will not show. Suggestions??
|
 |
 |
kevind
Posts: 251
|
| Posted: 11/03/2004, 9:00 AM |
|
If you're not using the editable grid to edit anything (updates/deletes) why not put a simply one row record form directly above or below a normal grid ?
I find formatting the style of the paragraphs above and below the grid and record from lets me get them pretty tight together on the page.
kd
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
|
|
|
Nielsen
Posts: 2
|
| Posted: 11/03/2004, 2:27 PM |
|
The problem with doing that is I can't seem to get the session variable to autofill the first column of the editable grid which is part of a multiple primary key. The whole idea here is to move from a record page with a person's information to a grid with rows of specific events. I have the session variable set and can pull the correct records into the standard grid, but I need to be able to correlate this value with the editable grid. I can't insert a null into the key and don't want to rely on the user to put the right number in the field. I am not a programmer, just a systems administrator that is perceived to be an expert in everything computer related. They just don't get it. Any help would be appreciated.
|
|
|
|
kevind
Posts: 251
|
| Posted: 11/20/2004, 12:14 PM |
|
Hi Nielson,
Let me follow this properly. You are probably using a link somewhere that contains a primary key representing the user. Then upon clicking this link you want to display a grid of all the records the user created - correct ?
It is not required that you display the Primary ID (or key) that relates to that person, just the fields that make up the data you want to display. Since you are using a session variable to control the grid of data - this key is known to you.
Now, to give the user the ability to add a new record I would place a record form directly below the grid. When building the record using the wizard, make sure you include the key field that would identify the person. In the before show event of the control for that key (found under events tab in the properties panel) you can add an Action to retrieve a value for a control from a session variable as you desire to do.
When you confirm that this record form is working, you can right click on the text box for the primary key field and change it to hidden so the user cannot see or change it.
If you need any more information you can send me a personal message (pm button below) and I can give you my e-mail address.
If you live in the Ontario, Canada area I might be able to do some work for you.
Regards,
Kevin
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
|
|
|
|
