3 Replies Latest reply on Aug 21, 2009 6:01 AM by comment_1

    Auto-enter calculated value



      Auto-enter calculated value


      I have 2 table;

          1. Clients [client_id(PK), client_name]

          2. ClientPIC [pic_ic(PK), pic_name, client_id(FK)]


      In Clients table, client_id is serial number.

      In ClientPIC, pic_id is calculated value.


      Let say I have 2 records in Clients table:

          1. C001, Yamagata

          2. C002, Printelligence


      And, 3 records in ClientPIC table:

          1. C001-01, Jessica, C001

          2. C001-02, Rachael, C001

          3. C002-01, John, C002


      If I have a new client PIC to register with details as below:

          Name: Michael

          Client: C002 


      How do I code the calculated value so that when the record is inserted to ClientPIC,

      it will give pic_id=C002.


      What commans to use?