Repeating information

[Savage]

Hi,

I have two problems.

Problem 1

I have created a drop down list for a supplier to select a group.

The information comes from a table of suppliers. The problem is there are
loads of suppliers in the same gropup but i only want the one heading in the
drop down list and for each heading to be there once and not repeated 30 -40
times.

Problem 2

Everytime i preview my form it asks for confirmation to retrieve data from
my database how can i make it automatic with noe message appearing

 

[Paresh]

Hi,

I have two problems.

Problem 1

I have created a drop down list for a supplier to select a group.

The information comes from a table of suppliers. The problem is there are
loads of suppliers in the same gropup but i only want the one heading in the
drop down list and for each heading to be there once and not repeated 30 -40
times.

Problem 2

Everytime i preview my form it asks for confirmation to retrieve data from
my database how can i make it automatic with noe message appearing

For problem 1, if you want to get unique supplier group records, you
will need to modify the SQL query that you are using to fetch the
records.

For problem 2, you will need to give full trust to your form.
However, this is not a recommended way. You can also try converting
your query data connection to its equivalent UDCx.

HTH.

Thanks,
Paresh

 

[Paresh]

Hi,

I have two problems.

Problem 1

I have created a drop down list for a supplier to select a group.

The information comes from a table of suppliers. The problem is there are
loads of suppliers in the same gropup but i only want the one heading in the
drop down list and for each heading to be there once and not repeated 30 -40
times.

Problem 2

Everytime i preview my form it asks for confirmation to retrieve data from
my database how can i make it automatic with noe message appearing

Hi,

For problem 1, you will need to change the SQL query that you are
using to fetch supplier group records.

For problem 2, you will need to givefull trust to the for. (Tools-

Form Options->Security). However, this is not a recommended way. I

have not tried this but you can also try converting your data
connection to its equivalent UDCX.

Thanks,
Paresh