Some of us routinely use views to rename columns to get around the linking column problem. As long as the view is a single table view, it is editable. You can use a single table view wherever you can use a table in a form.
--- Doug Hamilton <[EMAIL PROTECTED]> wrote: > Whoa! That was a subtlety I hadn't thought about: If you have a number > of single table views in one form, linked by aliased columns, then are > each of the views (well, really, the underlying tables) editable? Is it > only when you combine two or more tables into one view that they aren't > editable? > > So, if you can edit a number of single table views in one form, then my > idea of defining linking columns in a form among multiple tables is a > moot point - just use the views. > > Thanks for your r:esponse, Razzak. > Doug > > A. Razzak Memon wrote: > > > > > At 08:13 PM 2/20/2005, Doug Hamilton wrote: > > > >> How feasible would it be to allow us to define the linking > >> columns between tables in the form definition, probably under > >> Tables | Add/Remove Tables. That way we could link tables on > >> specified same-named columns. We could also link tables on > >> differently named columns, much like we do in WHERE clauses. > >> And since we'd be working directly with the tables instead of > >> views, the data would all be editable. (I'm assuming multi-table > >> views are not editable.) > > > > > > > > Doug, > > > > How feasible? > > > > Just remember, we can do R:Anything http://www.ranything.com > > and R:Everything http://www.reverything.com > > > > Meanwhile, if you simply define a single table view as > > explained in my earlier reply with two examples, and then > > use those views in a form, you should be able to edit any > > single-table view. That way you never have to tinker with > > the original (not normalized) table(s). > > > > Very Best R:egards, > > > > Razzak. > > > > > > ===== Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
