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.
