A calendar can be created easily in VB..but can the details be stored in Oracle...will it be too complicated?

I want to create calendars for different departments and store them in separate tables for a Patient Management system..

Please advice..

why store them in db? can't you just recreate the calendars whenever needed? If you want the calendars for storing other data in each date then you probably have a major table(s) design flaw.

Yes, I want to store multiple appointments on each date. The appointment table will have cid, month, date, dept_id, entry_1, entry_2...entry_6 as attributes. Does this table have a design flaw? I want to extract this information and display it on to the calendar in VB..

thank you

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.