Go to Related (imported) Record

[Jarvis]

I have a database with four tables.

I use this database to manage tasks in my cabinetshop.

One of the tables is a master task list.

This table contains all the tasks necessary to complete a particular style cabinet.

The other three tables contain task lists that are germane to specific components of the cabinets.

One table contains all the operations necessary to build a faceframe.

One table contains operations for drawer boxes

One table contains operations for end panels.

Etc.

Depending on the particular composition of the cabinet some or all of these processes are imported into the master task list.

Is there a way to navigate from the imported list to the related record from the imported table?

In other words, can I go to related record and be in control of what table this record is now viewed from?

[bcooney]

I'm confused by your structure. Why not have one task table (I'd call it a library) and a Components table. Then, create join records, since I'd imagine that a task may be used in the building of more than one Component. Task->Join<-Component

When you start a new job, I suppose you would be selecting Components, and they'd copy in their related Join records into the JobTask table.