> The new table name has to be the exact length as the old

the formopeninfo() thing makes sense, thanks.. but why the tablename length 
issue? what barfs if it's not the same?

--

Steven Green
Myrtle Beach, South Carolina, USA

http://www.OasisTradingPost.com

Collectibles and Memorabilia
Vintage Lego Sets and Parts
- and Paradox support, too
"Mark Bannister"  wrote in message 
news:5b966ab8$1@pnews.thedbcommunity.com...

You can change the master table when you open the form (just as you can
on a report) with formopeninfo structure.  It cannot be done on init,
although rather annoyingly Pdox has the ability to change any/all tables
on opening. We've all opened a form with a bad alias or table name and
had Pdox asked to find the table.

I actually do this with some fairly complex code by changing the table
name on the .fsl form, writing the new form to the priv directory and
then running that form.  The new table name has to be the exact length
as the old and it can appear multiple times on the form.

On 9/9/2018 3:23 PM, Kevin Zawicki wrote:
> I was referring to doing this in on the fly in the init via code.
>
> The "second table" is not linked.
> If the table is not there on design open you get prompted to choose 
> another
> table...  I am trying to do that in code.
>
> I want to open a form more than one time and have a unique master and 
> unique
> second table. Same structure.
>
>
> I am also experimenting with using a query in the DM. It seems to work as
> a table, a table in memory? I have to test, would each instance of the 
> form
> open unique table in memory?
>
>
>
>
> "Steven Green" <greens@diamondsg.com> wrote:
>> right-click on a field or table frame, define field / define table, hit
> the
>> little thing in the top left corner and it's the "data model" for the 
>> form,
>
>> without saving as a DM.. you can change everything from there, but it 
>> screws
>
>> up everything on the form, of course, and you have to re-size, re-place,
> etc
>>
>>
>> --
>>
>> Steven Green
>> Myrtle Beach, South Carolina, USA
>>
>> http://www.OasisTradingPost.com
>>
>> Collectibles and Memorabilia
>> Vintage Lego Sets and Parts
>> - and Paradox support, too
>> "Kevin Zawicki"  wrote in message
>> news:5b94616e$1@pnews.thedbcommunity.com...
>>
>>
>>
>> I have worked around this for years...
>> thought I would ask.= again.
>>
>> Any way to change table in the data model that is not the "master" table
>> on form init or open?
>>
>> or open a form based on a saved datamodel?
>>
>>
>