Since I'm adding the LinkCol column to each of the temp views, I suppose it is, by definition, a multiple table view; because I don't seem to be able to edit the data within the form.
So close and yet... -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Albert Berry Sent: Thursday, April 17, 2008 9:14 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Forms and multiple tables 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 >> >> >> >> >> > > > >
