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

    Unanswered: Reports question

    Hey guys,

    is it possible to create one report with data from two forms?

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    With data from two tables, yes.
    George
    Home | Blog

  3. #3
    Join Date
    Jan 2012
    Posts
    81
    i would love to know as when i go to create a report, i can only choose fields from that form and not the other forms

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Have a play with the query builder.
    Using this you can join two (or more) tables together.
    You can then build your report off of this.
    George
    Home | Blog

  5. #5
    Join Date
    Jan 2012
    Posts
    81
    cool, thanks...will see

  6. #6
    Join Date
    Apr 2013
    Posts
    226
    Quote Originally Posted by gvee View Post
    With data from two tables, yes.
    Now I'm confused, I thought BD didn't have tables in the traditional sense ...

  7. #7
    Join Date
    Sep 2011
    Location
    Australia
    Posts
    264
    Provided Answers: 2
    Should be no problem if you use related fields from another form (many to many or simple relations). This is your classic Invoice arrangement - Order to Line Items (MM*) and Order to Customer (1-1).
    Regards
    David
    * Note - In above example should really be 1 to M as line items usually refer to 1 order only (this can done in BD).
    Last edited by tamcind; 04-09-13 at 22:07. Reason: Add info.

  8. #8
    Join Date
    Apr 2013
    Location
    USA
    Posts
    132
    Provided Answers: 2
    You can display data on report only if you are setting up relation between two forms

Posting Permissions

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