Search results

I have read the suggested articles. Thanks My only concern regarding database is with orderscan table that is using two primary key fields. Moreover is the database normalized. Thanks again.

Hi, I have at last designed a small patient database for clinic. Kindly check the table structure / relationships and advise. Attached is the db file.

Thanks for info, I will be reading that. Have you checked my file. Do you think the relationships are fine or do I have to implement yours. Please advise as I am stuck with this relationship stuff.

Thanks for reply. I have made a database using you db structure with few modifications. File is attached. Few questions. 1. Relationships in sample database are a bit different than you mentioned. ., one doctor can send many patients from his clinic and one patent can be referred from...

Hi, Thanks for the table scheme. It appears to be fine . I need to add another table which shows different type of scans offered and their charges. So it will be\; Table scan. SCanid SCan name Scan charges. SCannotes Now the table you mentioned as scan will become scanorder. Table Scanorder...

Reagarding your post, it appears that my batabase is again not structured properly. MRNO is patient unique identification number generated when patient comes in. Format = 08-01-01, 08-01-02 etc. SCanorder are oders requested by patient and scanorderdetails are complete exam details including...

Hi, I have almost figured out the database to work. There is one issue with auto increment patient MR number. It is not the primary key. I have a field set to number and I want to set the value to year YY, month mm and three digit serial number with auto increment. So the format would be...

Hi, I had similar problem and I manage to fix it. When I type in cutsomer name and if the clinent/ customer is not in list, a box appears asking if I want to add customer. By pressing yes, a new form opens where info is typed in, and when this new form is closed this customer is added and next...

Hi, Guys I have been trying to make th form this evening for my four table patient database. Infact I have added a fifth table that shows the details of scan order placed. I have two questions. 1. How can I use a value of a field in subform to appear on the main form. 2. I am having problem...

All the doctor are from different specialities - surgery, medicine, Urology etc. They refer their patients for scans. So they need to be kept in a separate table. As far as relationships are concerned all of them are link using referential integrity. Now tomorrow I will mak a form to check how...

Ok. Great. I have four tables with relationships as mentioned. Should I check enforce referential integrity on all of them. I suppose I do need a form for entering data. Can I make an autoform for checking. Thanks.

Thanks, respect you all for help. I do about 2000 scans/ year. Its correct that I need two table, patient and physicians. Physicians are limited, about 100 that are referring these patients. Patient are many, but are usually all referred by physicians. I have physician table with all their...

Thanks a lot for replying. I really appreciate it. Sir, I have many patients who are referred to me by many physicians. 1. Each physician can refer many patients. I got this figured out so that multiple different patients can be entered with one physician or many physicians. 2. Each patient...

Thanks for reply. I want to make a small database for my own clinic. No commercial product is available. If you can kindly help with the table structure only. Thanks.

Hi, I am new to this post. I am a physician with interest in database designing. I have been trying to design a database for my clinic for few months but am unable to make one. I have been searching/ reading alot of info and came across this thread. Maybe someone can help me. Actually, I want to...