|item||in order y/n||remark#|
|is the building structure in order?||n||A001|
|are all the lights in working condition?||n||A002|
|remark#||description or explanation of remark||follow up date|
|A001||the south facing wall shows large cracks||june 2010|
|A002||second floor light not working||may 2010|
i want to create a ticksheet form to answer a series of questions, certain records (answers) might require detail - this detail i want to number in that specific place on the first form (CAN IT BE AUTO NUMBERED?) but the detail of the record needs to be on a separate form/page attached WITH the first form. Please assist with how i can go about achieving this.- much appreciated. In short - when the remark must be entered on the line, it should open the subform. (i know in Access database it can be done). Once again, much appreciated any assistance in this regard.