If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Brilliant Database > Brilliant database urgent help please

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
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
File Type: zip BD 2013.zip (333.5 KB, 15 views)
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Jul 2011
Posts: 131
Please find the answer in the attached file.
Attached Files
File Type: zip Modified BD 2013.zip (333.5 KB, 21 views)
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
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!
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
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!
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Jul 2011
Posts: 131
Please find the attachment. Hope your problem is solved now!!
Attached Files
File Type: zip re Modified BD 2013.zip (335.1 KB, 13 views)
Reply With Quote
  #6 (permalink)  
Old
Registered User
 
Join Date: Jan 2012
Posts: 81
thanks a lot again, it is now!
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On