Link to Form Field and Linking to Itself?

[Shane]

Hey all, I have a really weird application of the Link to Form field. Maybe this is more of a rhetorical question because I have a feeling you’re not supposed to use it in this way: in TF5/ TFPro I noticed that in the Link to Form pick list, you can select itself as the child form. I’m curious if this has a specific purpose or it’s just happenstance.

I am creating a task tracking system to organize all the things I do. Originally I would create a form to handle the tasks, then duplicate that form a few times to contain the levels of subtasks and use the Link to Form field to connect the parent tasks to the child tasks. The problem is the multi-level task system is limited to how many child forms I link with the Link to Form Field. If I was to program this in SQL, I would simply have a field that contained the ID of the parent task then use SQL to find the child tasks and display them with the parent record. I don’t know if there is a way to do something similar in TFPro without creating a chain of child forms.

I wondered if I could keep all the tasks in the one form, and use the Link to Form to itself so only one form is handling all the tasks. I didn’t think this would work, but surprisingly TFPro creates the “child” task/ record in its own table which looked promising (see screenshot). However when you click the new task in the Link to Form layout object in the record layout, it goes to that record, but doesn’t show the form fields.

Interestingly, in TF5 it will go to the “child” task fine, but then show the “parent” task in the Link to Form layout object (see screenshot).

I’m wondering what the intention is when linking a form to itself or if it can be used in a useful way. My guess is you’re not supposed to do it at all. :)

Thanks in advance and sorry for the long post!

• This topic was modified 3 days ago by Shane.

Attachments:

You must be logged in to view attached files.

[Shane]

I managed to get it to work with the Link to Form Join relationship (see screenshot) although you won’t see any changes update in the table of the multi-table list view until you click to another form and click back.

Of course this is not ideal in a relational database but I’m probably trying to push the limits on TFPro to see if I can accomplish something in my head. As I mentioned above, I’m trying to create a collection of tasks that are hierarchical with parents and siblings without using multiple forms. This allows endless children records without having to create more forms for each level of children.

• This reply was modified 2 days, 5 hours ago by Shane.

Attachments:

You must be logged in to view attached files.

[Author]

Posts