At 11:33 PM 2/20/2005, Doug Hamilton 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?
Correct.
Is it only when you combine two or more tables into one view that they aren't editable?
Very correct.
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.
You've got that one right.
Thanks for your r:esponse, Razzak.
Always a pleasure, Doug!
Very Best R:egards,
Razzak.
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.
