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
>
>
>
>   


Reply via email to