Create alias for tables
Posted: Tue Jun 21, 2016 1:41 pm
Sometimes, I need to use a table in more than one way. One user may be allowed to access all fields, while another user can only update one field. If I can clone a table, I can set them up seperately.
For example:
- table is called deliveries
- user1 enters delivery info
- user2 (who is the supervisor) needs to update just one field (while other fields should be read-only)
Also, using an alias can help to hide the table name in the filename URL.