Hi Paul, It was the second that I meant - the ability to have a main form with a linked subform. For example, you might have a main form displaying editable data for a specific teacher such as name, qualifications etc, and a linked subform (linked by a teacher id) displayed on the main form, containing a list of student records (name, contact details etc) for students of that teacher. I briefly skimmed the wiki looking for guidance on how to do that but I didn't see it labelled in the terminology I was expecting. Is there a wiki page on this specific process that can get me started? Apologies if I am asking something obvious to experienced DABO users but I am deciding whether this is worth investing a lot of time in or not.
In MS Access, I would make a subform e.g. fsub_students and put on the student controls e.g. txtfname. The underlying table might be students. I would then make a form called frm_teachers and add controls like txtqualifications. I would also add the control fsub_students selecting teacherid as the linked field. I could also choose to display the subform data as continuous forms or as a datasheet for example. I might also decide to allow data entry into the subform. All the best, Grant _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
