mikecabelas
01-21-2005, 09:30 AM
Is there a way to have multiple records under a record, such as top record 1 under it 1.1, 1.2 so on. then if you go back to the top record, new record 2 the records under it would be 2.1, 2.2. so on.
Thanks
Thanks
|
View Full Version : multi records mikecabelas 01-21-2005, 09:30 AM Is there a way to have multiple records under a record, such as top record 1 under it 1.1, 1.2 so on. then if you go back to the top record, new record 2 the records under it would be 2.1, 2.2. so on. Thanks pbaldy 01-21-2005, 11:04 AM Sounds like you need 2 tables, one for the main record and one for the "sub" records, with a field relating to the main table. mikecabelas 01-21-2005, 11:46 AM I have that. The problem is that I need multiple records for the second form/record/table off of the first form/record/table. In other words the first form/record/table (1) can have multiple records under it in the second form/record/table 1,2, so on, go back to the first form/record/table go to a new record, record 2 open the second from/record/table I need all the data in it to be specific to record 2 first table. I think what I need is a sub-record sub-table if there is a way to do that. Thanks!! Pat Hartman 01-21-2005, 12:33 PM For each level in the hierarchy, you would add a new "sub" table. Be sure to create relationships and enforce referential integrity. As a practical matter, I wouldn't create more than a three-tiered hierarchy. An alternative structure is a self referencing table. This structure works when a record has one and only one immediate parent. This structure is useful for corporate hierarchies. Each employee has only one supervisor who is himself an employee and has only one supervisor until you reach the top of the tree where the president's record has null in the supervisor field since he has no one to report to. Len Boorman 01-21-2005, 12:47 PM Is there a possibility here that you have a recursive situation Pat Hartman 01-21-2005, 07:53 PM Recursive is another word for self-referencing. |