You are more than welcome.
How I actually use this is to dynamically display a list of customers in
a form used to set report parameters. As the user selects parameters I
change the value of LinkCol in a temporary table based on the user
parameters. In this case, it is whether the Customer is Active, Inactive
or All customers, and whether or not the customer has Active, Inactive
or Any Parts.
The temp table is in a scrolling region, and also has a T/F check box in
the region and a column in the temp table CustPick TEXT (1) that the
user can use to select one or more customers. By changing the value of
LinkCol in the temp table to 1 or some other number the customers
magically appear and disappear.
Albert
Steve Martin wrote:
That would work! A little more overhead but hey, nobody would see
it...dbgrids and dbnavigators would still work...gotta nice beat, easy
to dance to...I'll give it a 7.
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Albert
Berry
Sent: Thursday, April 17, 2008 8:47 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Forms and multiple tables
You may create single table views for each table that have a column in
common, even though such a column does not exist. I use this for drop
down menus quite often.
CREATE TEMP VIEW vwCusts (LinkCol, CustID, CustName) AS +
SELECT 1, CustID, CustName FROM Customers
CREATE TEMP VIEW vwCities (LinkCol, CityName, State) AS +
SELECT 1, CityName, State FROM States
Ridiculous example, but you get the idea.
Albert
Steve Martin wrote:
Quick question for the group...
I want to use an Enhanced Control Tab in order to edit multiple tables
in a single form. The tables have nothing in common. Is there a way
to
fool the form so that it isn't looking for common columns?
Thanks,
Steve
