Newbie Questions

Re: external data source - unwanted data

lofly — Fri, 16 Nov 2007 15:55:10 GMT

Thanks Clay for reply; don't know what to do without you. you're da man :D

I put my filter in my secondary data source.

1. Point my data source to xml file

2. select NAME field to display

3. select filter on NAME field base on the form field.

My form field are field1, field2,field3,field4, field5, field6.

My secondary data source field are Country, Make, Year, Model, Color, NAME

I'm doing filter base on field1, field2,field3,field4, field5, field6. Cause that is the value that user selected. It doesn't give what I want.

I'm not sure what you mean by "placed your filter on the wrong item"

thank you for your help

==========================

I get it. Thanks Clay again

filter on Country is equal to field1 ..........

sweet

Re: external data source - unwanted data

lofly — Fri, 16 Nov 2007 15:16:47 GMT

thank you for reply

as you see in the above picture, it was preferred to Name not ID

Re: external data source - unwanted data

Clay Fox — Fri, 16 Nov 2007 15:11:46 GMT

From what I can see your filter is on the name field not on the client drop down.

You would need to edit the dropdown, I believe you want some cascading drop downs. You can do a search and find lots of examples for cascading.

I am not sure if you are putting a filter on data in your main data source or the secondary but I believe you have placed your filter on the wrong item.

Re: external data source - unwanted data

adamrharding — Fri, 16 Nov 2007 13:35:41 GMT

Could this be that although the display name is TOM is the data being recorded actually something different like TOM's ID. If so, then the filter would have to reference his ID not TOM.

Cheers

Re: external data source - unwanted data

lofly — Fri, 16 Nov 2007 13:27:01 GMT

it's not working when I try field6 is not equal to TOM.

not sure what to do, help please

Re: external data source - unwanted data

adamrharding — Fri, 16 Nov 2007 11:24:31 GMT

This is because TOM is defined as a client in your datasource. You would either have to filter out TOM or modify the datasource to achieve this.

Cheers

Adam

external data source - unwanted data

lofly — Thu, 15 Nov 2007 21:53:04 GMT

TOM should not show up in my Client drop down list. Do you know why?

Thank you for your help. I'm appreciated.