Page 1 of 3 123 LastLast
Results 1 to 15 of 38
  1. #1
    Join Date
    Nov 2013
    Posts
    8

    Unanswered: how to pass data from one form to another

    okay so am new to brilliant database and I have the following
    in the first form I have a field where I can choose COMPANY NAME
    and many other fields that I should fill up such as quantity price and so on
    I also have a button that says issue invoice
    when I press this button a new form opens
    in this form I want the company name [selected in form one ] to be shown plus the price and the quantity
    [ for each company the price and quantity are different ]

    please help me
    I rly need help am stuck

  2. #2
    Join Date
    Jan 2013
    Posts
    24
    It would be nice to be able to do this easily....

  3. #3
    Join Date
    Jan 2014
    Posts
    46
    When you say open new form with the fields filled in, do you mean a report to print, or a new data entry form?

  4. #4
    Join Date
    Jan 2014
    Posts
    46
    Am I missing something, or didn't "rly need help"?

  5. #5
    Join Date
    Sep 2011
    Location
    Australia
    Posts
    264
    Provided Answers: 2
    Hello
    I would normally set a global variable to required field value with a script triggered by select form or comfirm edit of form (or use both). This value is then available to any other form. Attach script to your button to set a field to this global as well as any other needed actions.
    Not sure as to how you have set up price/quantity but often can use lookups or query/global variable.
    I would recomend any BD user to master the "for each record" cycle as this is a very useful function to manipulate data. You must always ask yourself how will BD "know" which record to act on - the above cycle is often the key to this.
    Regards
    David

  6. #6
    Join Date
    Jan 2014
    Posts
    46
    David's advice above is invaluable. How does the database know which record to act on is something I need to remember, and will solve many of my script errors. Thank you!

  7. #7
    Join Date
    Oct 2013
    Location
    Philippines
    Posts
    103
    This problem can be solve using simple relational field which can link to another forms in the database. This is a little bit tricky, but you just need to understand how it works
    Attached Files Attached Files
    Last edited by mcmichael; 02-02-14 at 18:34.

  8. #8
    Join Date
    Oct 2013
    Location
    Philippines
    Posts
    103
    Please check the sample database file.

  9. #9
    Join Date
    Jan 2013
    Posts
    24
    I can not get the downloaded files to open. they download and unzip fine, but give an error message of invalid header. tried several combinations of browers and unzippers without luck. using BD 9.42 Pro. I have had this issue before and using Chrome to download the files was a workaround for me. but that no longer works...... I hope its not the version i'm using. not really ready to upgrade at this point in time

  10. #10
    Join Date
    Jan 2014
    Posts
    46
    Unfortunately, it is your version. I had the same problem until I upgraded. It's a shame BD doesn't have a "save as" previous version option.
    Don

    PS Below is my simple interpretation of what was needed. Maybe I made it too complicated.


    Just got zip working...MyDB2.zip
    Last edited by donaldp; 02-03-14 at 16:46. Reason: add zip file

  11. #11
    Join Date
    Oct 2013
    Location
    Philippines
    Posts
    103
    Just try downloading the trial version of v10.54B and see how it works

  12. #12
    Join Date
    Jan 2013
    Posts
    24
    yea......its the version.

  13. #13
    Join Date
    Jan 2013
    Posts
    24
    here is a VERY short video of where I would like to pass info to another form...


    YouTube

  14. #14
    Join Date
    Jan 2014
    Posts
    46
    I'm not a you-tuber. Do I need a password to view this or do I need to sign up to youtube? Can you download an example instead?

  15. #15
    Join Date
    Jan 2013
    Posts
    24
    no accnt needed. just click the link.

Posting Permissions

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