Hi, I have a week layout where for each day I need both vertical and horizontal field. for instance I have times going vertically and three fields per time going horizontally. so it would look something like this

.........Tom | Joe | Bubba
6:00
7:00
8:00
etc

one record would have fields Time, Name1, Name2, Name3,

I have that for each day so what I have done is just created 7 datagrids and placed them next to eachother ( no easy task the placing part ). I there a better way to do this ?
I certainly hope so.

Thanks for help
Raif

Hi Raif,
I dont know where you have this problem,do you have this problem in your datasource(I mean the Table diagrams wasnt designed in a satisfiable manner) or just you have some problem with the page layout and you cant locate them beside each other ...
if you have first problem I can help you ...

--------------------------------------------
Mehdi.:)

Hi Mehdi,
Well, I'm not sure which problem I have either. If I can get all my info into one grid then I don't have to worry about the page layout. Let me tell you what I have going on. I have two tables, a tblDateTime and a tblDetail. they look like this
tblDateTime:
Date
Timeslot
isslotfilled
nameinslot

then

tbldetail:
StartTime
EndTime
Trainername
Clientname
Datetime

lets say I have a three hour workday ( wouldn't that be nice ) then for each date in tbldatetime there would be three records
1/1/2004 7:00
1/1/2004 8:00
1/1/2004 9:00
1/2/2004 7:00
and so on
the istheslotfilled field says how many apointments there are scheduled for the timeslot if it has reached it's limit it returns "filled"
when you click on one time it opens the detail window which creates a new record for date,time,and next available slot number and then you enter the details like client name and what time session ends.

so that is the breakdown ( somewhat simplified for clarity ). If I want to see how many available slots there are per time for one day, no problem right just get a datareader for that date. However, I need a week view. if I do an sqlstatment for between these dates I get multiple records thus a long (vertical) datagrid. What I want is the basic outlook, act, whatever scheduler weekview. What It looks like I'm reduced to is having 7 datagrids with 7 seperate datareaders (or as dataset with tables).
Any idea's either on the main topic or otherwise would be greatly appreciated. If anything is unclear please let me know
Thanks
Raif

Raif,
you could make more tables .... I didnt get your scenario completely but surely you should make new tables for better working with them ...
i.e for date in your tblDateTime you should(its better) make another table includes tree rows according to your tree hours ...
(I couldnt get the end partition of your post very much ...)
HtH.

--------------------------------------------
Mehdi.:)