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
