Problem with Report/Subreport/Image

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • evildracko
    New Member
    • Jul 2010
    • 14

    #1

    Problem with Report/Subreport/Image

    Hi, longtime lurker first time poster.

    I am developing a Db for school on assambling planes etc... well i have my tables

    Model
    Pk MID autonumber
    Model Name txt
    Model Type txt

    Pices
    Pk PID autonumber
    Piece Number txt
    Piece Description txt

    this are the only ones that are independent.

    Index
    IID primary key
    MID FK to Model MID
    Group txt
    Description txt
    image txt
    comments txt

    and Assambly
    EID Pk autonumber
    MID FK to model MID
    IID FK to index IID
    PID FK to piece PID

    Position number
    quantity number

    Ok so i created a report called "Sub Assably" wich is used in a Form called "Assambly". I have a imageFrame that is updated with the image path from index.

    The sub form normally works fine, however i have found that my problem is with the detail section of Assambly wich has "can grow" = yes

    therfore, when a sub assambly gets to long it goes to a new page.

    Here is my question [i know finally]

    Is there any way that when the page is change, the picture is in there too?

    ok here is a quick example...

    reddit alien is not golden yuo can see this
    Attached Files
    Last edited by Niheel; Jul 22 '10, 07:42 PM.
  • evildracko
    New Member
    • Jul 2010
    • 14

    #2
    solved by creating a new column with the page number... not clasy but working

    basically inside de sub form made it so that there can not be mote than N columns and making on the value on new column to number page and created a Child master and sorting and grupoing through that value

    Comment

    Working...