Hi,
I have 6 tables, Table1 to Table6. Table1 is Grand-Grand father and Table6 is Grand-Grand son. Table1 has the fields: ID (PK), Name, Desp. All other tables have the fields: ID (PK), Name, Desp, No (FK).
What kind of technique can make this work easily? Can I create a main form for Table1 and create 5 subforms for the rest tables and put them on the main form? I just read some Helptopics about subforms and am still not clear about it. The HELP says:” A main form can have any number of subforms if you place each subform on the main form.” Does this mean: I can put many subforms on the main form to build up a hierarchical form with several levels?
I am looking forward to hearing from you . Thanks a lot. Chris
I have 6 tables, Table1 to Table6. Table1 is Grand-Grand father and Table6 is Grand-Grand son. Table1 has the fields: ID (PK), Name, Desp. All other tables have the fields: ID (PK), Name, Desp, No (FK).
What kind of technique can make this work easily? Can I create a main form for Table1 and create 5 subforms for the rest tables and put them on the main form? I just read some Helptopics about subforms and am still not clear about it. The HELP says:” A main form can have any number of subforms if you place each subform on the main form.” Does this mean: I can put many subforms on the main form to build up a hierarchical form with several levels?
I am looking forward to hearing from you . Thanks a lot. Chris