Skip to Content
0
Former Member
Sep 02, 2004 at 06:46 AM

Formatted search

66 Views

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