Lux Aeterna
Board Regular
- Joined
- Aug 27, 2015
- Messages
- 201
- Office Version
- 2019
- Platform
- Windows
Hello everyone.
I have created an excel workbook where I write down our daily patients. I would like those daily info to be stored in a database, from which I'll be able to draw info next time those patients visit again.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]NAME[/TD]
[TD]Father's name[/TD]
[TD]Phone[/TD]
[TD]RN[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Mike[/TD]
[TD]Aaa[/TD]
[TD]1001[/TD]
[TD]12345[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]John[/TD]
[TD]Bbb[/TD]
[TD]2002[/TD]
[TD]23456[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Maria[/TD]
[TD]Ccc[/TD]
[TD]3003[/TD]
[TD]34567[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Cathrine[/TD]
[TD]Ddd[/TD]
[TD]4004[/TD]
[TD]45678[/TD]
[/TR]
</tbody>[/TABLE]
I would like every day to store specific info: Date (not included in that sheet right now, but I will add it), ID, Name, Father's name, RN, Phone) and to be able to search for them in the created database using their RN. So that, when I search in the database RN "12345", it will give me all Mike's info.
Moreover, I would like to be able to draw info from that database, so when a patient visits again I will submit their RN and fill out all fields (Name, Father's name, Phone) automatically.
Hope my message makes sense...
Thanks a ton
I have created an excel workbook where I write down our daily patients. I would like those daily info to be stored in a database, from which I'll be able to draw info next time those patients visit again.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]NAME[/TD]
[TD]Father's name[/TD]
[TD]Phone[/TD]
[TD]RN[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Mike[/TD]
[TD]Aaa[/TD]
[TD]1001[/TD]
[TD]12345[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]John[/TD]
[TD]Bbb[/TD]
[TD]2002[/TD]
[TD]23456[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Maria[/TD]
[TD]Ccc[/TD]
[TD]3003[/TD]
[TD]34567[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Cathrine[/TD]
[TD]Ddd[/TD]
[TD]4004[/TD]
[TD]45678[/TD]
[/TR]
</tbody>[/TABLE]
I would like every day to store specific info: Date (not included in that sheet right now, but I will add it), ID, Name, Father's name, RN, Phone) and to be able to search for them in the created database using their RN. So that, when I search in the database RN "12345", it will give me all Mike's info.
Moreover, I would like to be able to draw info from that database, so when a patient visits again I will submit their RN and fill out all fields (Name, Father's name, Phone) automatically.
Hope my message makes sense...
Thanks a ton