If I understand your question:
As far as I know Filemaker records only go down the page (not talking about labels)
So the design needs to follow that model.
What I am trying to achieve is this:
Monday Tuesday Wednesday Thursday Friday Saturday Sunday
Which is on the same principles as a cross-tab query. From this layout you can see at a glance was timeslots are available and not.
I expect there will be some weird and wonderful way to achieve what I want....I just need to find it.
bcooney - wow! Just what a beginner needs, inspiration. I did actually manage to achieve what I wanted by:
Created first table containing the WeekNo and RoomNo
Created tables for each day of week, each table having the time slots covering the two week period I need and a booked field.
Created a relationship between each day of the week and the first table with WeekNo and RoomNo as the keys
Set up layout based on the first table and added portals for each day of the week for; the first portal displaying the time slot field
Headed up each portal with the relevant day of the week using the text label thing and now I have exactly what I wanted. Layout displays records for a particular Week (Current or Coming) by Room No and I can see whether it has been booked out or not - it looks exactly like a calendar!
But thanks for suggestions.
I am impressed
Thanks for the calendar suggestions but the problem with the traditional calendar/appointments thing is that it is 2 dimensional. I need an extra dimension to be able to display music lessons for each room for each day. In your typical 2-D I could have got one room but then not create any unique entries for the other rooms where the lessons were on the same day at the same time.
I was originally trying to persuade my Music Teacher, the guy I am writing the database for, to do it in SQL DB, as that is where I am most profficient. However, being 'creative' he preferred the MAC solution. And, in some respects, I quite like it...I was just daunted by the'macro' approach to scripting, which is still a bit clunky for me....but I could yet be converted!
Thanks everyone, no doubt you will be hearing more from the two-week old Filemaker 11.0 developer!