About Keygroups

Business Central/NAV User Forum
1

Hey Everybody,

I’m beginner for Navision,Can u Pls explain about Wat is Keygroups,
Where this keygroups are used n How to create keygroups…

Thanks for ur valuable Times

2

KeyGroups are an easy way to enable / disable a group Keys (you can call it indexes) in tables. Keys in DB’s can increase performance. But if you don’t need it can also decrease performance.

For example in NAV 5.0, you have a key group for Serial Numbers. If you don’t serial numbers you should deactivate that keygroup. To enabled / disable all that keys in several tables related to tracking it would a hard work. By simply deactivating keygroup all keys related to this keygroup will also be deactivated.

It’s also the way to end users without a developer license to maintain indexes.

3

thanks alot for yours valuable time…,but i also want to know how to create a keygroups in nav…,

4

do u mean how to create key group in Nav 4.0 ??

5

Hello,

You can declare a KeyGroup under a Table Keys Properties.

To enable or disable a key group for sorting, click File, Database, Information and the Database Information window appears. Then click Tables, Key Groups and the Database Key Groups window appears. You can then enable or disable a key group by clicking the appropriate button.

I’ve never been used this option but I think it effect for the sortings, but it is increase the database size a lot! … maybe… [*-)]

6

no that is not how you declare a keygroup… [:|]

Open any table in design mode, then open the keys window, and make the ‘keygroup’ field. Type in any name into that field, let’s say you call it ‘whatever’. Save the table, you just created the keygroup ‘whatever’.

Now to enable or disable keys that have the value ‘whatever’ as the keygroup, you go to the database information window and disable/enable them there.

7

Hey Denster

Thanks for ur valueable sugesstion…I tried wat u said.,I declared a key Group for a table XXX.After declare that key group i saved the table but i cant find the declared keygroup in a Database->Information->Tables->Keygroups.Wat else to do to see that declared key group

Thanks in advance…

8

First of all, you should check out the application designers guide, which will give you answers to most questions like this. You can find this document on the product CD, in the ‘Doc’ folder, and it is called “w1w1adg.pdf”.

So you add the keygroup ‘whatever’ to a key in the table designer. Then you go to Database, Information, Tables, Keygroups. On the left side, you type in ‘whatever’, and on the right side you select either ‘enabled’ or ‘disabled’, or you click the enable or the disable buttons. this will automatically enable/disable any key that has the keygroup ‘whatever’.

9

Thanks alot DenSter[Y]

10

You’re welcome, glad to help you find the information you needed. [:)]