Is there any way to create 2 subtables for a main table?
Posted on 2006-04-17
Our lawfirm MS Access database has multiple tables and forms (as does everyone). Often, I, meaning ME, want to look at a table of data (NOT A FORM) with 2 subtables. Main table is CONTACTS, subtables are LITIGATION INFORMATION, and MONIES IN. The main table key is "CONTACT ID," an autonumber field for CONTACTS; The subtable key for LITIGATION INFORMATION is "ID," an autonumber field, and the subtable key for MONIES IN is "INVOICE #," also an autonumber field;
I want the parent field as CONTACT ID, and the child fields to be ID and INVOICE #. However, when I use both fields, it restores back to AUTO each time. Any suggestions?
Please be advised, this IS NOT FOR MY USERS, this is only for my use (usually, it's a quick and dirty table search for data not searchable by the users). Is there any way to have the multiple subtables...YES, I already know it is not the preferred way, but it's just for my usage. Can it be done, and if so, how?
Thanks for your help guys, much appreciated in advance.