Problem Remains for Linking Data to Child Table

[Scott24x7]

I have a form that I'm trying to get to work "interactively" with a parent form.
The difficulty I have is I use a template table structure, which creates another table with a unique name, so that in a multi user environment I don't have a collision.

The difficulty is, when I call the form (DO FORM CHILDFORM.SCX) I created that form using the template table fields, so the controls are bound to that form. In the controls, I have changed the control sources to <alias>.<fieldname>.

I found in the form the "BindControls" property, which I set to .F. and in the form INIT I open the Template, copy the structure to the table with unique name, and then alias the table name (which I thought I could then use in the control source).

The purpose of the form is to stage some data before continuing and when done, control will go back to the parent form, but I think everything will be "done" in this form before returning.

So, the problem I have is, is there a way to use the temporary table, which I have aliased as TEMPDBF to this form as the control source? And if so, what am I missing?
Thanks.


Best Regards,
Scott
ATS, CDCE, CTIA, CTDC

"Everything should be made as simple as possible, and no simpler."

 

[Tore Bleken]

Try lcCompanyControl = "this.txtCompanyName

 

[Scott24x7]

tbleken, I just want to say, I really appreciate you hanging in here with me on this. Can't tell you how frustrating this point has been for me. I will give that a try now.
Cheers.

Best Regards,
Scott
ATS, CDCE, CTIA, CTDC

"Everything should be made as simple as possible, and no simpler."

 

[Tore Bleken]

Note that I am not saying that this is a solution to your problem, it was meant more like a tip.

 

[Scott24x7]

Yeah, I appreciate it... I've been trying to think of other ways to do this, but I also am surprised that (to my thinking) it's so complex to point a form at a record source that 100% matches the source it was "created" with, and if you don't "create it with one" then how do you go about assigning them at run time... I can accept I'm taking the total wrong approach, but I don't see a "how" otherwise. It does feel like I'm missing something obvious. The latest test failed as well.


Best Regards,
Scott
ATS, CDCE, CTIA, CTDC

"Everything should be made as simple as possible, and no simpler."

 

[Scott24x7]

Some progress...
A change in strategy...

What I was doing was taking the template table (TTPARSEBC) and creating a blank version from the structure.
Then I would select a blank work area, and USE that table, and alias is to TEMPPARSE

What I am doing now is, I copy the structure, then release TTPARSEBC, then open the other table, and ALIAS it to TTPARSEBC, so has the same name, same structure as the original table. But this frees TTPARSEBC up to act as the template (so worst case, someone tries to open it, they get a "table in use will auto-retry in 5 seconds" at which time it will work, as this whole process to build the temp table is sub-1 second.

Now, the oddity is I still have 4 fields that aren't binding properly (and yes, COMPANYNAME is still one of them.) But the others bind. So I'm now wondering if that's a "sequencing" issue as the form loads, so I'll play with that for a while, and see if I can get it sorted out...
At least I have some different... different is good!


Best Regards,
Scott
ATS, CDCE, CTIA, CTDC

"Everything should be made as simple as possible, and no simpler."