Coupling two tables in Access and setting as subform source
Posted on 2008-10-14
OK this might be an easy answer, but I'm still learning on Access. I have Access 2003 database with a main form with a source table (we'll call TABLE 1). Contained within this main form is a subform with a separate table source (TABLE 2). I have reached the 255 max number of entries in TABLE 2, but I still need to add more fields to this table as well as on the subform. The only thing I could think of is to somehow create another table with these additional items and somehow couple it to TABLE 2. But since the subform can only link to one table, I wasn't sure how to accomplish this. Thoughts?