darren166
Posts: 24
|
Posted: 02/13/2004, 7:48 AM |
|
Most developers have tables that reference other tables by a foreign key. Quite often these are just being used as a descriptor for a field, e.g. using 'CountryId' in a contact details table that references a table called 'Country'.
When you build an editable grid you will want to be able to sort rows by the description rather than the id so the best option is to use joins to link all the descriptors to the main table. Also if you are using one of the fields as a label it saves having to do an extra Lookup (eg in a record form)
The downside of doing this is that you now have to specify custom insert, update and delete methods.
It would be good if the editable grid / record wizard could take account of this and not create the need for custom actions. Obviously it would need to ask which is the main table and whether it is the only one being updated, but that wouldn't be too much.
Darren.
_________________
---
a. w. d. - c o n s u l t i n g
Midnight Oil Consumers. |
|
|
|