Manage Lookup Tables

 

The Lookup tables allow you to manage the list boxes you have in your system. You can add new entries, modify existing entries and delete the unwanted entries form any list box used in the system. Usually, you need to use Lookup tables when you find a commonly used entry in any of the list boxes missing. 

 

For example to add dark pink color in the Colour list box used on the Fruit/Flower tab in Manage Add new window, you need to use the Lookup tables.

 

Figure 9-1 shows the Colour list box used on the Fruit/Flower tab in Manage Add new window.

 

                        Figure 9-1

To modify a list box entry using Lookup table, you need to:

 

  1. Click Browse my plants button on the Welcome screen of the My Garden Pal desktop software, as shown in Figure 2-1.

  2.  

                            Figure 2-1

    Your garden window appears, as shown in Figure 4-1

     

                                                                Figure 4-1

     

  3. Select Manage lookup lists menu item from the Tools menu, as shown in Figure 4-4.

  4.  

                                              Figure 4-4

     

     

  5. Select the name of the lookup table that you want to modify from the Select lookup table dropdown, as shown in Figure 9-2:

 

                                                            Figure 9-2

 

The name of the list and the entries of the list appear in the list box available on the Lookup table page, as shown in Figure 9-3

 

Figure 9-3

You can now:

 

 

 

 

Note:

My Garden Pal will not allow you to edit or delete an entry that is already in use in any of your plant information. If you want to modify or delete any such entry then you must find the plant with that entry (using search criteria) and change the plants data to another entry before editing or deleting this entry.