Jarvis Posted October 30, 2011 Posted October 30, 2011 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 Posted October 30, 2011 Posted October 30, 2011 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.
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now