Multiple language database setup?
I need to create a multiple language product page and I'm setting the database now.
What is the best approach to get the best results with WA DB2?
I would create a product main table with all product fields that do not need translation.
And then I would create a product tanslation table containing all fields that are translatable along with the language field and the product_id foreign key field.
But how can I do this with WA DA pages?
I create a basic set of admin pages using WA DA pages using the main product table.
In the Insert page I would add a repeat region that will loop all languages and would display all fields from the translation product table.
Then I add a second insert record behaviour (or multiple insert record) to the page.
I think I need to remove the redirect from the first insert record server behaviour and set the proper redirect for the second insert.
Is this correct, or is there a better way to do this?