jswalker4
Posts: 8
|
| Posted: 09/25/2005, 5:25 PM |
|
Hi,
Hoping someone can help me. I need to create a master detail page and the sample does not seem to help me at all. What I have currently is a search grid that looks up an address in a table. I would like to make an editable grid that would allow the user to click on the rec_id of the address (it's unique) and that would open up the editable grid and allow the user to continue to add records to the grid that are related to the address that they chose in the search screen above. I have done this in Access many times with the subform property but I thought it would be easier in CCS. Any other examples I could look at out there besides what is included in the documentation. Any help is appreciated as I committed to a project due this week b/c I thought it would be easily done with CCS...
Thanks
Jeff
|
 |
 |
Edd
Posts: 547
|
| Posted: 09/26/2005, 6:40 AM |
|
Jeff,
The grid / editable grid is a fairly easy sceanrio or an I simplifying your issue.
The Address grid when clicked the passes the rec_id as one of the primary keys for the ediable grid. The ediable grid will have a number of blank rows where people can enter information.
You will need to do change the insert method on the ediable grid to be a custom insert / table. In this way you can utilise pick up the rec_id that was passed as part of the URL to populate the database when it is inserted. I assume the rec_Id is a hidden field on the editable grid (make sure it's attibute is set to "not required" otherwise you get error messages on the insert).
The major issue that windows programmers need to get thier head around in that updates don't occur until the page is submitted - so going from access you need to trian people to hit the update button.
These are some examples in the knowledge base (somewhere) on utilising Javascript to hide empty rows until you need them. But I suggest getting the basics done first.
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
jswalker4
Posts: 8
|
| Posted: 09/26/2005, 9:58 AM |
|
Edd,
I appreciate your response! Thanks. I have already created the first grid that contains the address information by using the search builder but there is nothing really for anyone to click, only search for a record that appears in the grid if the address is found.
After I figure that part out, you're saying use the editable grid builder and make those changes regarding the insert. I do understand the difference between web programming and Windows and the fact that you're basically disconnected until the next button press. I will check out how I would make something 'clickable' in the first grid
Jeff
|
|
|
|
DonB
|
| Posted: 09/26/2005, 5:04 PM |
|
Just select a control (Label) and change its type to "Link". Or, you can
add a new Link control to the grid (perhaps after adding a new column as a
place to put the Link. I like to use an ImageLink myself, as a small "edit"
icon takes up very little space.
The href of the link will be the primary key of your detail form, of course.
--
DonB
http://www.gotodon.com/ccbth
"jswalker4" <jswalker4@forum.codecharge> wrote in message
news:6433828ae3ed51@news.codecharge.com...
> Edd,
> I appreciate your response! Thanks. I have already created the first grid
that
> contains the address information by using the search builder but there is
> nothing really for anyone to click, only search for a record that appears
in
> the grid if the address is found.
> After I figure that part out, you're saying use the editable grid builder
and
> make those changes regarding the insert. I do understand the difference
between
> web programming and Windows and the fact that you're basically
disconnected
> until the next button press. I will check out how I would make something
> 'clickable' in the first grid
> Jeff
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
|
