Access SQL conversion to Sprint DB Pro

[Mike]

Hi,
Please excuse the length of this post but I thought would be necessary to
explain. I am barely a novice with sql syntax so it's very helpful that
access builds it for me. I have created 4 combo boxes on a form where they
retrieve and base the results from one then the other and other etc.,
creating a sort of drill down menu. It works just fine in Access but when I
copy the control sql to the Sprint db control it fails because the Sprint db
does not recognize forms. I sent the Access sql to Sprint db support and
they responded with the syntax that was supposed to work. It seems as if I
have tried everything possible but I just can't seem to get it right. I have
pasted the correspondence below. Please review and provide an example using
the Access sql converted to their syntax.

Thanks for your help!
Mike

From: <[email protected]>
To: "'mhmobile'" <[email protected]>
Subject: RE: Basing one combo box on another
Date: Mon, 10 Sep 2007 20:26:53 +0900

Hi,

To refer a control on a from, you have to use notation:
&control_name

For example,
SELECT table1.* FROM table1 WHERE table1.field1=&combo1

If you are new to SprintDB Pro, please try the step-by-step tutorial in
the
user manual.
You can download the user manual from:

http://www.kaione.com/Online_Store/Register/Downloads/downloads.html


Best regards,

Kim
mailto:[email protected]
www.kaione.com



_____

From: mhmobile [mailto:[email protected]]
Sent: Monday, September 10, 2007 5:09 AM
To: (e-mail address removed)
Subject: Basing one combo box on another


Hello,

I'm not sure if this support includes help with the program but I thought
I'd ask anyway. I'm have 4 combo boxes that I'd like to base results from
one to the other and so on to create a drill down type menu. I am able to
do
this with Access but so far not with the demo of SprintDB Pro. Below is
the
sql that Access uses, /SprintDB seems to have a problem with the "where"
portion of the syntax.

Thanks for any guidance you can provide.
Mike

combo1:
control source location_id
row source SELECT tbl_Location.location_id, tbl_Location.Location_Desc
FROM tbl_Location
ORDER BY tbl_Location.location_id;

combo2:
control source land_id
row source SELECT tbl_Land.land_id, tbl_Land.Land_desc
FROM tbl_Land
WHERE (((tbl_Land.location_id)=[Forms]![frm_Lighting]![combo_location]))
ORDER BY tbl_Land.land_id;

combo3:
control source building_id
row source SELECT tbl_Building.Building_id, tbl_Building.Building_Desc,
tbl_Building.land_id
FROM tbl_Building
WHERE (((tbl_Building.land_id)=[Forms]![frm_Lighting]![combo_land]))
ORDER BY tbl_Building.Building_id;

combo4:
control source facility_id
row source SELECT tbl_Facility.Facility_id, tbl_Facility.Facility_Desc,
tbl_Facility.Building_id
FROM tbl_Facility
WHERE (((tbl_Facility.Building_id)=[Forms]![frm_Lighting]![combo_bldg]))
ORDER BY tbl_Facility.Facility_id;