Hi
I have a table :
| F1 | date |
| tom | 2008/1/1 |
| john | 2008/1/2 |
| jerry | 2008/1/3 |
| frank | 2008/1/4 |
Can I use section access to control users access data bwtween two dates?
USER1 can access 2008/1/1~2008/1/3
USER2 can access 2008/1/1~2008/1/4
...
USER3 can access date1~date2
If use section access, do I have to link such table as:
| USER1 | 2008/1/1 |
| USER1 | 2008/1/2 |
| USER1 | 2008/1/3 |
| USER2 | 2008/1/1 |
| USER2 | 2008/1/2 |
| USER2 | 2008/1/3 |
| USER2 | 2008/1/4 |
| USER3 | DATE1 |
| USER3 | … |
| USER3 | … |
| … | … |
| USER3 | DATE2 |
My question is: if userX can access 300days' data, do I need to link a 300rows table? or sth better idea?
Can I set a date range in section access?
