Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 4781 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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?

Posted

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.

This topic is 4781 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.