Assigning Tables to a form

[woodyinoz]

Hi all,

I currently have 3 tables upon a form.
I want to be able to have some code under the button that opens the form, which will allow me to open the form using 3 different tables depending upon the users input.

For Example if the User enters 803-402 I want the 3 tables that the form uses to be:
803-402A.DB
803-402B.DB
803-402C.DB

Or if they enter 828-002 then the tables used on the form should be:
828-002A.DB
828-002B.DB
828-002C.DB

etc.....

Does anyone know how this can be done?

Thanks in advance,

Woody.

 

[Langley]

Basically, if both sets of tables are in the data model, then you can change the tableName value (under properties) for your field(s), MRO(s), or tableframe(s) when the form is opened. I've never done it with multiple or linked tables, but as long as the data model for the form is correct, then it probably should not matter.

I would simply pass a variable (writeEnvironmentString) identifying which set you want to use, then assign the appropriate tableName(s) to the MROs or TableFrames and do a forceRefresh.

Mac

"There are only 10 kinds of people in this world... those who understand binary and those who don't"

langley_mckelvy@cd4.co.harris.tx.us