Nested multi-reference insert

[mebeingken]

I’ve been using the subtable feature on insert/update along with form repeats and they work great.

Now trying to include a subtable multi-reference inside a multi-reference of a subtable.

Table structure is:

quotes
quote_prices
quote_price_transhipments

Every quote has a multitude of prices and prices have a multitude of transhipments.

In the db manager, prices properly shows all fields as a subtable of quotes.

However, transhipments does not display all fields. The subtable multi-reference under prices is seen, but it does not show all columns.

Wappler shows:

External db manager shows:

I was expecting to see the transhipments subtable here (but it does not):

Can anybody see any errors with this structure?

Are nested subtables multi-reference tables supported?

[sid]

@mebeingken

Are nested subtables supported?

I have used nested subtables, but only for select/query.
No idea about insert.

The missing columns could be because they are used by the nested logic to be filled automatically by the parent identitiy value.

[ben]

I’ve gone berserk with a lot of CRUD success.

[mebeingken]

Thanks guys for the input.

It looks the difference for me is these are multi-reference tables, not subtables (I’ve edited the title).

I’ve tried to recreate using the wappler db manager and run into similar issues.

@patrick Let me know if I can provide anything here to assist.

[patrick]

I believe it is currently only possible to insert/update a single level deep, so the main table and its sub tables, not the sub tables within sub tables. With querying it is possible to have multiple levels of sub tables.

[mebeingken]

Thanks for the confirmation…I’ll stop trying. Can easily go another route on this.