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..

Recommended Answers

All 2 Replies

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, learning, and sharing knowledge.