isladogs
MVP / VIP
- Local time
- Today, 22:01
- Joined
- Jan 14, 2017
- Messages
- 18,209
I use exactly the same type of approach as in MajP's last example.
Normalised table used to store data but temp 'crosstab' style table used for user entry and display.
I was interested to see this as I hadn't previously seen anyone else using the same approach
I also use this method for both room and equipment bookings and for other examples including parents evening appointments and student attendance registers
Normalised table used to store data but temp 'crosstab' style table used for user entry and display.
I was interested to see this as I hadn't previously seen anyone else using the same approach
I also use this method for both room and equipment bookings and for other examples including parents evening appointments and student attendance registers