Hi all,
I have some issues when doing my formatted searches.
I am currently working on SBO 2004 PRE III.
I have made 2 userdefined tables, called Country and City.
Country includes Code,Name and Landcode like
1,Norway,47
2,Denmark,45
City includes Code,Name and Landcode like
1,Oslo,47
2,Bergen,47
3,Viborg,45
I have then created 2 userdefined fields in Documents called Land and City.
Land Is connected to my country table.
What I want is that when I select a Country in my Land field in a salesorder it will display the citys connected to the landcode of my selections.
I have found this rather difficult, and my issues is mainly.
1. Does a user defined field accepts multiple field in formatted search? (Like returning 2 citys into my City field when selection Norway as country)?
2. What query should I use to get this working. Tried the following ones..
Failes:SELECT T0.U_Landcode FROM [dbo].[@Country] T0 WHERE T0.Name = $[$U_Land.0.0] but when
setting in the parameter as a hardcode like SELECT T0.U_Landcode FROM [dbo].[@Country] T0 WHERE T0.Name = 'Norway' it works.
Any one having some good solves to my problem?
regards
Vidar Kalsund