5 level table design then display

[Guest]

i've designed a 5 level table :
customers, projects, details, labor, materials
one customer can have many projects,
one project can have many details
one detail can have many labor and/or materials

problem is that when I pull up the table in the "table"
open, i can click the + sign to go one level deep from
customers to projects, and then click it's + sign to go
one more deep into details, but then I don't see any more
plus signs to go deeper into the labor and/or materials -
does access only allow 3 deep ? i set these up with the
wizard, which allowed me to define 1 detail to many labor
and materials - and if i open the labor table, i see the
+ sign that shows the detail it's related to.

help

 

[Tim Ferguson]

problem is that when I pull up the table in the "table"
open, i can click the + sign to go one level deep from
customers to projects, and then click it's + sign to go

Please don't use table datasheets to interact with data. Use forms and
reports and queries, which is what they are for. And then you get the
opportunity to choose exactly what tables and joins are used for any
particular purpose.

B wishes


Tim F