aboyce
Posts: 6
|
| Posted: 08/08/2006, 9:04 AM |
|
hi,
i have a page with a record form that displays a support request from the CSS_REQUESTS_TBL.
i have added a grid to the same page and i want the grid to display any assignments from the CSS_ASSIGNMENTS_TBL where the css_assignments.srid = css_requests_tbl.srid.
how is this possible??
_________________
Boycey |
 |
 |
Waspman
Posts: 948
|
| Posted: 08/08/2006, 11:51 PM |
|
What is css_requests_tbl.srid?
Is it loaded when the page or record form is loaded?
Can it be saved as a session before the grid is show and then used in a where statement?
Tony
_________________
http://www.waspmedia.co.uk |
|
|
|
aboyce
Posts: 6
|
| Posted: 08/14/2006, 2:15 AM |
|
css_request_tbl.srid - srid is the record id for the css_request_tbl table. both record form and grid are loaded at the same time
_________________
Boycey |
|
|
|
Waspman
Posts: 948
|
| Posted: 08/14/2006, 5:29 AM |
|
so can you show a grid based on whether the records match css_request_tbl.srid and assign the same to a new request?
Tony
_________________
http://www.waspmedia.co.uk |
|
|
|
wkempees
Posts: 1679
|
| Posted: 08/14/2006, 7:25 AM |
|
So you have 1 page with a record form and a Grid.
When this page is displayed there is am identifier on the URL or in the POST parameters that tells you recordform what to display.
Easily to find, open the SQL for the recordform and look at the WHERE clause.
Now in the GRID's SQL you will have to add to the WHERE clause :
WHERE css_assignments.srid = css_requests_tbl.srid (type URL or POST
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
