Razzak,
You are an absolute GENIUS. I used the SEL AS to
create my view for the form, relocated the ID numbers on
the form and the regions and it worked. Now the form
is driven from my view and the subordinate tables
display only the rows with the current ID. This opens up a
whole new world of application development for me. Can't
possibly thank you enough. Besides the fact that you gave
me the answer in under an hour. Once again, this list
serv, this product and Razzak are GREAT!
On Sun, 08 Jul 2001 12:53:36 -0400 "A. Razzak Memon"
<[EMAIL PROTECTED]> wrote:
> At 12:20 PM 7/8/01 -0400, Bob Powell wrote:
> >
> >... The resulting STUDS2 view contains everything I need.
> >I just can't get the form subordinate tables to display
> >only for the current ID.
>
> Bob,
>
> Make sure to use "AS Columnname" option for column names
> when creating views to identify proper column names!
>
> For more details and examples, check out:
>
> http://www.RSyntax.com
>
> Under User Reference, check "SELECT AS" option for details.
>
> Have Fun!
>
> Very Best Regards,
>
> Razzak.
>
>
> ===================================-============================
> Official R:BASE List Server: mailto:[EMAIL PROTECTED]
> RBTI Events/Training: http://www.rbase2000.com/events
> R:DCC Members: http://www.rbase2000.com/rdcc
> ================================================================
> R:BASE, Oterro & R:Tango are registered trademarks of RBTI.
> ==================================-=============================
>
----------------------
Bob Powell
The Hotchkiss School
Lakeville, Connecticut
Systems Administrator
[EMAIL PROTECTED]
