We have here a weird requirement and i don’t know if 4D can solve this and how, and if there isn’t a solutions, at least a workaround will be appreciated
Here we have a table of companies that will become the reference table for all other tables that are tangled to this, for example, invoices, quotes and others, but there are too many tables, well, talking to people here in the company they said that in other software that they used, they can change dynamically from company to company, and all information joined to it changes accordingly.
I think that those software changes from one database to another. I wonder if 4D have a way to do this, like we have many data files with the same structure and we can use it while users change the company, maybe opening and closing it
I already read the command OPEN DATA FILE, but it closes current opened data file and opens the next data file, but it shut down all sessions opened, so it can’t work for us
i appreciate all help you can give to us