Multiple language database setup?

Hello,
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?

Example:
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?

TIA
tony

This sounds like a good solution. It would probably require a little bit of hand coding to do this efficiently. If you had one insert or update server behavior and looped on the supported languages... then you could name the form elements with the appended language id and loop through updating all of them.

This is something I could help with in a premier support ticket. It is definitely possible, but requires some careful setup and a few lines of code by hand to pull off. The heavy lifting can be done with Data Bridge, but some of the intricacies need to be done by hand. Do the database the way you are describing since that seems like a logical structure.