TOPIC: New User - Stuck on IDcontrol
#1091
New User - Stuck on IDcontrol 2 Years, 6 Months ago
Sorry I am sure I have done something silly, but I can't see it.

I have two table rlcontact and rladdress, rlcontact has a IDcontrol field of rla_num from rladdress.

Code:

rladdress
    (rla_abbrev, rla_country, rla_line2, rla_line3, 
        rla_name, rla_num, rla_postcode, 
        rla_region)
    index unique (rla_abbrev)
    index (rla_name)
    key (rla_num)

rlcontact
    (email, firstname, lastname, rla_num, rlc_num, 
        website)
    key (rlc_num)

Field_rla_num  :  
Field_num
{
Prompt: "Address"
Control: (Id "rladdress" "rla_num"')
}



I have a couple of records in the address file, but when press the arrow to get the prompt up in the field for rla_num when entering a contact, I get an error box or the debug box up with "no usable keys" and the whole page seems to lock up.

I am sure I have done something silly any idea what please?
 
 
#1093
Re:New User - Stuck on IDcontrol 2 Years, 6 Months ago
You can change the "index (rla_name)" to be "key (rla_name)" and recreate the table rladdress. Using the SchemaView to check it before you go to the screen. You can find more information in the User's Manual -> Going Further -> Using IdControl.

Judy
 
 
#1095
Re:New User - Stuck on IDcontrol 2 Years, 6 Months ago
Thanks I will give it a go. I had read that section, but I will try re-reading it.