Associate existing child record to existing parent record from parents table.
I have two related tables, a Parent and a Child. The way users typically use my app, they often find themselves wanting to associate new Children to a Specific Parent record, without actually knowing what specific Child records they might want.
Right now if I want to associate an existing child record with a specific Parent, I have to remember that Parent name, then go into the Child table and search for a relevant Child.
Since in my case searching for a relevant Child might be a long and involved process, it is easy to lose track of which Parent you are intending to associate the Children with.
What would be more useful is if there was a way to, from from a specific Parent record, generate a report of all un-linked Child records, and easily associate them with that specific Parent.
I have been looking into generating such a report using the Quickbase API and a formula URL field on the Parent table, but so far no luck.
This is an odd and specific case, so I would not be surprised if it wasn't possible, but it would be surprisingly helpful for our workflow.
Thanks.
Right now if I want to associate an existing child record with a specific Parent, I have to remember that Parent name, then go into the Child table and search for a relevant Child.
Since in my case searching for a relevant Child might be a long and involved process, it is easy to lose track of which Parent you are intending to associate the Children with.
What would be more useful is if there was a way to, from from a specific Parent record, generate a report of all un-linked Child records, and easily associate them with that specific Parent.
I have been looking into generating such a report using the Quickbase API and a formula URL field on the Parent table, but so far no luck.
This is an odd and specific case, so I would not be surprised if it wasn't possible, but it would be surprisingly helpful for our workflow.
Thanks.
