Moods
|
| Posted: 01/09/2002, 1:40 AM |
|
I am trying to use a single mySQL database in all of my sites. I have a table in my database named "division", different countries have different divisions so i added a "country_id" column to the table which relates to another table containing all the countries we operate in. On my forms how do have a ListBox that only displays the divisions for a specific country using the "country_id"?
I'm guessing i need to add a custom lookup SQL in the field properties, can anyone help with this. If you need further details please ask. I am using ASP
Thank you
|
|
|
 |
Alex Alexapolsky
|
| Posted: 01/09/2002, 4:31 AM |
|
Try this lookup sql (modify field names if needed)
select division_id,name from divisions where country_id = " & fldcountry_id & "
|
|
|
|
Molly
|
| Posted: 04/30/2002, 9:31 AM |
|
I tried to use the suggestion to the "Country Code" question but now my list box shows nothing. Any ideas?
Data Ex.
SA_Table
Sa_id1 Joe FK_Group_id1
Sa_id2 Matt FK_Group_id1 2
Sa_id3 Sara FK_Group_id1
SA_group_table
Group_id1 Group1 FK_sa_id1
Group_id2 Group2 FK_sa_id2
What I want to show in the List box:
Joe (This name shows as default because he is currently the sa_id1 associated with the group1)
Sara
*The table on the Record form is SA_group _table
*Key field
FK_sa_id – List box
*List – Lookup SQL
Select sa_id, UID
from sa_table
where FK_sa_group_id = " & fldFK_sa_group_id & "
|
|
|
|
kipdole
|
| Posted: 01/22/2003, 1:35 PM |
|
select division_id,name from divisions where country_id = " & fldcountry_id & "
Did this work for anybody. I can't get it to work? I keep getting missing operand?
|
|
|
|
jayme
|
| Posted: 09/10/2003, 3:57 AM |
|
like to know if this worked?
if so, please notify me:jayme27@hotmail.com
This is just dependent list boxes right?
|
|
|
|
|
