how to set source table in form.

I have a requirement in which i need to connect the server using odbc and then connect my form using a table from the server.

How can i setup the source table for a form at runtime?

Appreciate any help on this regards.

Hi Kami,

Can you describe what the solution you are tring to acheive?

I am trying the assign a DATASOURCE TABLE NAME AT RUNTIME.

To set the SOURCETABLE PROPERTY to the table name.

i.e. FORM.SOURCETABLE = ‘CUSTOMER’;

how to do this how to set the source table name from the code at run time.

Hi Kami,

This is not possible - but you still didn’t explain the overall problem - there may be other solutions e.g. Form.Run( 0, or using a temporary table.