How would it be possible to join three tables on a single layout using a three portal heirarchal format? Or a single table?

I have three tables WorkAreas -> WorkGroups -> WorkTasks.

I would like to add a line item to the WorkArea table, select that WorkArea line item and add multiple WorkGroup line items to that WorkArea line item. Then do the same with the WorkGroup; select the WorkGroup line item and add multiple WorkTask items.

Production (WorkArea) ->

-----Machining (WorkGroup) ->

----------Beam Saw (WorkTask)

----------CNC (WorkTask)

-----Sanding (WorkGroup) ->

----------Drum Sander (WorkTask)

----------Stroke Sander (WorkTask)

----------Hand Handing (WorkTask)

Install (WorkArea) ->

-----Safety Training (WorkGroup)

I am adding a unique code to each entry type. This will expand throughout the system to additional tables for prefixing barcode. I also require a way to validate the uniqueness of the code.

Thank you,

Mark

Perhaps you mean something like this?

http://fmforums.com/forum/showpost.php?post/334277/

comment, I've been wondering for some time now how you are able to find and link to previous relevant posts. Do you have them bookmarked? Do you search for them? Do you remember them?

seriously, I'ts quite impressive :worship:

Thank you comment

I did a few modification and seem to have it working. I will post the working as requested. I added an extra table occurance and a couple of script triggered scripts to do this. File pending...

Mark

Do you have them bookmarked? Do you search for them?

Some bookmarked, some searched for. Keep in mind you only see those that I did find...

Attached is the updated file with Parent, Child, and Grandchild with selection highlighting and active field highlighting. I have not figured out a way to allow new entries to the parent self-join portal too, as there is no record created at the time of entry. Anyone else have an ideas?

Thanks to comment for the original file.

NavPortal3.zip