Search results

Check Wix.com, I think it is easier than wordpress.

You need marketing advisor, for your business, if you don't understand marketing concepts.

New academic year has to be created by a simple add form to academic year table from the administrator.

Select the academic year in the main form, and filter all queries on the subsequent forms based on this selection.

Another approach is to organise tables in tree schema, if possible, and make academic year root of tree - I am referring to relationships here. Each root branch then would specify distinct academic year.

What about timezone?

https://www.essentialsql.com/learn-to-use-union-intersect-and-except-clauses You might find some answers...

It seems SQL is not properly defined. Try to debug runtime SQL query expression.

Just a simple advice, try first simple arguments, then replace them gradually by complex expressions, so that error can be spotted.

Check the Cycle property of the form. It might provide some solution in helping you staying at the current record.

Follow the steps from the video: https://youtu.be/YZKN_-P6wck

You should try splitting the table into two tables with one to many relationship.

I believe the arrows at comboboxes are custom, also custom seems to me the form minimize button.

How is it possible to modify forms even to the point of custom arrows in combobox and actually to customize every attribute of any control ?? sample screens HERE

I believe all SaaS solutions use a common database for all customers. I do not know for sure, I guess they do that.

I understand that "physical" separation into several distinct databases is the most secure one. I search for alternatives making compromises on some issues.

The same method is embedded in mssql 2016. Looks like a low level secure method. https://channel9.msdn.com/Events/DataDriven/SQLServer2016/Row-Level-Security

The following is a method for record level lock - per user - regarding mySQL. Looks promising. https://www.sqlmaestro.com/resources/all/row_level_security_mysql/

I feel that managing multiple BE databases will be a nightmare. I will test it and see how it goes. I thing the single database with a guid 128 bit companyID is hard enough to break. I will test each method.

I am thinking of adding foreign key companyID to every table and relate all tables to company table, then all queries will be restricted by the specific companyID field. Database: MySQL or MSSQL