Change Primary Key

Dear All, I have problem with Table, for example my table is Customer and primary key is No., In other hand I crate a form that using Customer table but I don’t want to use No. field as my key, but “Our Account No.” as my key. Problem is if I change the primary key in Customer table it will impact to other form that already use that key. In my experiences in other programming environment, I can make a logical table that refer to physical table, this logical table is to accomodate different primary key. my question is can I declare another key but does not impact to other form that already exist. Thank You very much [V]

In the customer table you can define your key and than use customer.setcurrentkey(“our account no.”), or set the sorting property in the SourceTableView to your new key. Michael