Invoices and TImetables

[englishnewbie]

Is there any way that you can implement a timetable into a database, for example there are Cust. Details, Lesson Details tables and i want to show the name of the customer and the time the lesson starts anf finish on a weekly timetable sheet then can be printed off??? also can you put buttons into table views?

any help will be greatly appreciated!

[Sanjai]

You can create a timetable structure and a weekly report could give you the information in the required format. Give me some more details on how your application should work so that I can design a database structure. You can add button on a layout in table view except that it cannot be seen in browse mode .

[englishnewbie]

There are two tables

customer details and lesson details

customer details holds, first name, surname, address, phone numbers and license number, pk_customer_ID,

lesson details holds the: date of lesson, day of lesson, start time of lesson, finish time of lesson, cost of lesson, pk_lesson_ID, fk_customer_ID

So far the database can add new customers and lessons, search through customers by name and can give invoices of how much each customer owes.

There is one teacher so i need to show on a weekly calender that can be printed when he has lessons and where he has frees so he knows where to book.

Thanks in advance for any help