We having the following thing in Servoy, i hope we can get some advice about how to do this:
A user has the ability to switch between different locations.
A product has a table with data which is the same for all the locations and also several subtables related to it with data which can be different depending on the location.
When a user adds a new product, a record should be created in all the subtables with information for all locations.
After that, the user can also add data in the subtables, that are specific for each location.
(For example, we have a product table and a supplier subtable. When adding a new product, a record is created in the supplier table, with data for all the locations.
After that, you can add more records in the supplier table, which are specific for each location.)
When selecting location A (which has it’s own specific data in a subtable), only this record should be displayed. Not the record which contains the data for all locations.
When selecting location B (which has no specific data in a subtable), the record for all locations should be displayed.
Some forms contains over 10 fields from different subtables to show in the detailform.
Then we have also the following that in some casses we have a tabpanel where we need to show the location specific data and the data what is for all locations together.
What is the best way to do this in Servoy?