Paul
|
| Posted: 01/25/2002, 2:42 AM |
|
Can anyone see why this won't work?
SELECT number_id, branch_number
FROM branch_numbers, branch
WHERE branch_numbers.branch_id = " & GetParam("branch.branch_id") & "
I want the grid to display in a listbox for each record in grid all the telephone numbers from the branch_numbers table where the branch_id of that number is equal to the branch_id in the grid.
Any ideas?
|
|
|
 |
Nicole
|
| Posted: 01/25/2002, 4:39 AM |
|
Paul,
add one extra to the form, set its type to ListBox, go to its properties and define custom sql like:
select branch_id, branch_number from branch_numbers where branch_id = " & fldbranch_id &"
GetParam() function is used to get the value of parameters passed through URL string.
|
|
|
|
|
