jgoodman00
Programmer
- Jan 23, 2001
- 1,510
I have a form which contains information such as survey date, survey type etc, stored in a table called tblInspection. This is viewed as a datasheet, as a subform whereby an object in the main form will have many surveys carried out on it, which are stored as a continuous list on the datasheet. Ok, this is fairly simple, but the more complicated part is another subform which is related to both the main form & the survey date subform. This form contains cost data related with the survey date information. i.e. a survey is carried out & work required with respect to this survey is then listed. This also forms part of a one-to-many relationship with the main form, & a one-one relationship with the survey date subform.
My problem is how do i display the required record on the work required subform. I have linked it by a masterID (which drives the whole db), but this is not unique with respect to the survey & work required data. I have also tried making the primary key of the survey date table a field in the work required table, but the record is no longer updateable. Any suggestions anyone?? James Goodman
j.goodman00@btinternet.com
My problem is how do i display the required record on the work required subform. I have linked it by a masterID (which drives the whole db), but this is not unique with respect to the survey & work required data. I have also tried making the primary key of the survey date table a field in the work required table, but the record is no longer updateable. Any suggestions anyone?? James Goodman
j.goodman00@btinternet.com
