<i><font color="#663300">
In codebook you suggest to create: one table - one view. There is a problem with PK generation.
You also suggest not to create relations, only views based on tables.
</font></i>
Greetings Jacek,
Correct, mostly. Use views for all your user interfaces. No more tables. If you will edit the data in a view, mark the fields from the joined table as non-updatable. Or better, each updatable view is from one table. Use multiple views to provide lookups and combobox sources,etc.
If possible, and it is possible, do NOT let user edit in a grid. Use the grid to display data only. Then let them go to tab 2 where a single record is displayed as a form for editing.
Another tip: Use one bizobj for one updatable view.
Look for the message "New User". It has a few sources that you can download and get examples of just this approach. Once you start using this approach you'll find it works well and is easier to maintain.
HTH,
James Sayer
©2001 James Sayer |
