Bil Simser
|
| Posted: 04/26/2002, 11:28 AM |
|
Hi guys. Hope someone can help with this question.
I have a page that displays a single record to the user for editing (a Use Case but that's not important). I have another table that contains a list of open issues for this use case (with a field in that table for the Use Case ID to match on). I want to display all the associated records in the open issues table in the single record for the use case that the user is editing. The form should look something like this:
Use Case Form
Name: Field
Description: Field
...
Open Issues
1 - Open Issue #1 <- these come from the open issue table based on the UseCaseID
2 - Open Issue #2 <- these come from the open issue table based on the UseCaseID
...
Click here to Add a New Open Issue <-- URL to Open Issue form
The open issue list has to come from the open issue table using the reference number from the current record. Seems simple enough, I'm just not sure how to do it completely in CodeCharge. I already have some code (ASP) in my BeforeShow event on the form to replace some labels so I'm assuming I do something like this, maybe building the td tag with the data. Could someone possibly take a minute and help me out with a code snippet? Thanks for your time.
liB
|
|
|
 |
Dean
|
| Posted: 04/26/2002, 5:13 PM |
|
Bill,
I've not read your question very closely but I think I know what you want to do.
The form which lists the "related issues" needs to know which records to extract and show based on the Use Case. If the ID for the use case is the same as the ID used to identify related issues then this is pretty simple.
Assuming that you have already pointed the related issues form at the appropriate table and chosen the fields you wish to display, simply, add an input parameter to your related issues form which is mapped to the common database key field. Once you do that, CC will pass this parameter into the SQL that is used to find records for the related issues form.
If I have understood you correctly, you do not need any custom code or events to achieve your goal.
--
Dean
deanpm@ntlworld.com
|
|
|
|
Bil Simser
|
| Posted: 04/26/2002, 7:53 PM |
|
Hi Dean,
Yes, if I put a second grid form on the page I could hook it up with input parameters and all that jazz to display only the ones I want to see. However I want to have the open issues listed in the same form as the one I'm editing (for the use case) making it appear seamless. That's why I think I need to have some ASP code that replaces a label or something with the records from the open issues table. Thanks.
liB
|
|
|
|
|
