I've done a forum search on the subject of "Coded Lookups" but the threads do not seem to apply to my problem. The Coded Lookups work a treat but each time a coded lookup field gets focus it builds a couple of indices each time, but does them so fast I cant see the record total to give me an idea as to which table is being indexed.
Parent Table "Logging Field" has the following lookup rules:
Coded Lookup Field Name1 = Op_Unique (c,8)
Lookup Table: Appendix_C.dbf
Linking Field : Appendix_C->Unique (c,8)
Display Order: Base
Table "Appendix_C" has two indices:
Name "unique", on field "Unique", no filter, ascending, all
Name"Operator", on field "Operator", no filter, ascending, all
Coded Lookup Field Name2 = B_Unique (c,8)
Lookup Table: Base_details.dbf
Linking Field : Base_Details->Unique (c,8)
Display Order: Base_Details->Base (c,48)
Table "Base_Details" has two Indices:
Name "unique", on field "unique", no filter, ascending, all
Name "Base", on field "Base", no filter, ascending, all
Coded Lookup Field Name3 = ac_unique (c,8)
Lookup Table: aircraft_type.dbf
Linking Field : aircraft_type->ac_unique (c,8)
Display Order: aircraft_type->Aircraft_Type (c,48)
Filter : .not.generic (L,1)
Table "Aircraft_type" has four indices:
Name "ac_unique", on field "ac_unique", filter = ".not.generic", ascending, all
Name "ac_unique1", same as index "ac_unique but without the filter
Name "Aircraft_T", on field "aircraft_type", filter = ".not.generic", ascending, all
Name "Aircraft_T2", same as index "Aircraft_T" but without the filter
Coded Lookup Field Name4 = c_unique (c,8)
Lookup Table: Prefix.dbf
Linking Field : Prefix->Country_U (c,8)
Display Order: Prefix->Country (c,25)
Filter : Prefix->Usage_C (L,1)
Table "Prefix.dbf" has four Indices:
Name "Country_U", on field "country_u", filter = "usage_c", ascending, all
Name "Country_U2" same as "Country_U" but without the filter
Name "Country", on field "Country", filter = "usage_c", ascending, all
Name "Country2", same as "Country" but without the filter
I thought I had all the necessary indices defined, but apparently not, is there a way of trapping these temporary indices to see what the correct index definitions should be?
Also, whilst on the subject, these coded fields only allow nine characters to be typed into the field, which can make the lookups a pain in the ass, on some lookups, I have to scroll down the drop-down list a dozen lines or more to get to the correct selection, can this be changed to a larger number of characters and if so how?
Parent Table "Logging Field" has the following lookup rules:
Coded Lookup Field Name1 = Op_Unique (c,8)
Lookup Table: Appendix_C.dbf
Linking Field : Appendix_C->Unique (c,8)
Display Order: Base
Table "Appendix_C" has two indices:
Name "unique", on field "Unique", no filter, ascending, all
Name"Operator", on field "Operator", no filter, ascending, all
Coded Lookup Field Name2 = B_Unique (c,8)
Lookup Table: Base_details.dbf
Linking Field : Base_Details->Unique (c,8)
Display Order: Base_Details->Base (c,48)
Table "Base_Details" has two Indices:
Name "unique", on field "unique", no filter, ascending, all
Name "Base", on field "Base", no filter, ascending, all
Coded Lookup Field Name3 = ac_unique (c,8)
Lookup Table: aircraft_type.dbf
Linking Field : aircraft_type->ac_unique (c,8)
Display Order: aircraft_type->Aircraft_Type (c,48)
Filter : .not.generic (L,1)
Table "Aircraft_type" has four indices:
Name "ac_unique", on field "ac_unique", filter = ".not.generic", ascending, all
Name "ac_unique1", same as index "ac_unique but without the filter
Name "Aircraft_T", on field "aircraft_type", filter = ".not.generic", ascending, all
Name "Aircraft_T2", same as index "Aircraft_T" but without the filter
Coded Lookup Field Name4 = c_unique (c,8)
Lookup Table: Prefix.dbf
Linking Field : Prefix->Country_U (c,8)
Display Order: Prefix->Country (c,25)
Filter : Prefix->Usage_C (L,1)
Table "Prefix.dbf" has four Indices:
Name "Country_U", on field "country_u", filter = "usage_c", ascending, all
Name "Country_U2" same as "Country_U" but without the filter
Name "Country", on field "Country", filter = "usage_c", ascending, all
Name "Country2", same as "Country" but without the filter
I thought I had all the necessary indices defined, but apparently not, is there a way of trapping these temporary indices to see what the correct index definitions should be?
Also, whilst on the subject, these coded fields only allow nine characters to be typed into the field, which can make the lookups a pain in the ass, on some lookups, I have to scroll down the drop-down list a dozen lines or more to get to the correct selection, can this be changed to a larger number of characters and if so how?
Comment