Enable Child Records#83

I can’t figure out how to use the WP editor to show/hide child records. I have a table of orders and table of items with multiple items for corresponding orders. I see how I can create the table join, but I’m not sure why I would when it doesn’t seem possible to show related (LEFT Joined) records. I thought some combination of Master/Sub functionality and grouping would do the trick, but if so, I’m not sure how.

Yes, I and probaby many others need this too. Pretty basic functionality for a commercial database plugin, I find.

This functionality is desperately needed. Any update from wpDataTables developers?

Basically this could be accomplished with foreign key relation, if only there wasn’t that limitation preventing the use of a multi-select box.

I’m also one of these who are very interested in having this functionality… just submitted a ticket asking about the limitation and if anything could be done about it.

I would be using this for linking compatible accessories to products.

A two-way relation would be really neat, I mean that you could see the related items from either end, but only needed to specify the relation on accessory or product side. (Also, many accessories would be compatible with several products.)

In my scenario though, the other end would work reasonably well just by filtering the product table by the accessory, so it would be enough just to have the accessories column with multi-select capability.

a Many-to-man is accomplished via a join table…and I’ve done that in my implementation, but it would be super-helpful to be able to see related records in detail view.

the Details plugin does not say that it will display child records…only large numbers of columns in its view.

I’ve moved in to use AppSheet. It automatically maintains two way relationships. Less work, more features.

Oh, that’s a good point I completely missed..! Definitely have to explore those join tables though.

I’m just about to do my first tests this week so everything has been theoretical so far… so even if I could select multiple related records (accessories in this case), I couldn’t get them clickable for details.

Well, that’s a pity and yes I agree this child record functionality would then be very much essential anyway.

(no the status still didn’t change… sorry if you got your hopes up)

I’m just commenting that the brand new feature “Transform cell values” combined with #108 (when it’s ready) might be something interesting… at least for showing the related records, I mean..?
But I’m still very much hoping too they’ll be planning some proper child record functionality in the near future, since completing #108 enables them to create many new things based on that.

Thanks. I’ve also moved to AppSheet. Not using data tables these days.