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.