Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2012
    Posts
    81

    Brilliant database urgent help please

    Hi all,

    I need some help with part of my database. I have attached the database for anyone who is capable to help to demonstrate the solution. I will like when i select a client in the database that a set of charges are automatically entered into the 3 charges field.

    For example when i press the 'select client' button and choose company1, i will like $10 to enter into charge1 field, $20 to enter into charge2 field and $30 to enter into charge3 field.

    When i choose company2 i will like $40 to enter into charge1 field, $50 to enter into charge2 field and $60 to enter into charge3 field.

    Thanks in advance!
    Attached Files Attached Files

  2. #2
    Join Date
    Jul 2011
    Posts
    137
    Please find the answer in the attached file.
    Attached Files Attached Files

  3. #3
    Join Date
    Jan 2012
    Posts
    81

    Thumbs up

    Quote Originally Posted by asokram View Post
    Please find the answer in the attached file.
    MANY THANKS BROTHER!!!....perfect!

  4. #4
    Join Date
    Jan 2012
    Posts
    81
    One problem though asokram, the other fields for the client is not populating automatically (address field, phone number fields, bir field, reg field). Would like these to populate also...can you modify the sample again please? This will be greatly appreciated, and thank you for you time and patience!

  5. #5
    Join Date
    Jul 2011
    Posts
    137
    Please find the attachment. Hope your problem is solved now!!
    Attached Files Attached Files

  6. #6
    Join Date
    Jan 2012
    Posts
    81
    thanks a lot again, it is now!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •