I know that quite a few manufacturers use common components between pushbuttons ind indictor lamps yet I see that we have seperate tables for both types of items even when there is quite an overlap (illuminated pushbuttons for example).
Now when you add an entry to the catalog database, you can assign the sub components to items. This is all good.
However the problem I see is when you have to add items to two different tables for the same usage. I'm going to use Schneider push buttons and indicators as an example.
In the same style of pushbuttons and inidicators, schneider have standard parts that can be used on both. When I added the Pushbutton I had no problem with any of the sub components. However when I added the indicators and tried to use the sub compnents that had already been entered for the pushbuttons, I found that they had to be entered again.
If we could select subcomponents that are located on different tables, it would do two things at least.
1 - reduce the size of the database overall. Less duplicated entries means less space wasted.
2 - faster speed when accessing the database.
I have also run into the same thing with Fused Terminals. The fuse carrier is listed as part of the TRMS table, but the fuse is listed in the FS table. You have to either do a mnaul lookup or add the fuses to the TRMS table or the Terminal Fuse Carrier (and accessories) to the FS table
Regards Brad