General information
Category:
Coding, syntax & commands
>Hi Mike,
>I want records reorederd in right table not only in grid and without indexes on tables and
>without field which connects rows; rows on right are grouped together for left row, then follows rows for second left row and so on ...
>Regards, Gojko
Hi Gojko,
Yes this can be done programmatically but if you don't use indexes, even hidden to the user it gets slower and slower every time when records added.
Another penalty is that if no "key" is used between records in table A and B, after even a small corruption you are mixed to the greatest mess ever. Every time you open, look or reorder table B, the situation is "static" and hard to repair after a possible corruption OR user error (yes those can happen in real world) but with a index/relation key (you can use even a third "hidden to user" table to relate tables A and B) the situation is "dynamic" and much less harm you will get.
AT
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only