Print Service Memo

[foxtet]

Hi every one,
I'm a new user of ms access. as a part of my assignment i'm working on patient database by access 2003.

I want each patient to be given a service memo from the counter at the time of registration. and also if the patient seek any service from any department he/she will be issued a memo prior to service rendering.

if any one can build this module for me it can be a great help....

fox

[blue4512]

Start by making sure you have the following tables created; patient, registration, department, service

Create a form for the patient, with a subform for the registration and look-up fields for the other tables

Lastly create a report that shows all relevant information

- Patient table - first name, last name, ID, Address, City State, Zip Code, Phone Number, etc.

- Registration - Date, time, notes, location,

[foxtet]

Thank u
in the price list the amount is different to locals and foreigners..what i wanted to do is that at the time of registration if the patient is foreigner that memo window must filter rates for foreigners only.... any help
fox

[foxtet]

Thank you for the help

Pls go through the attached file for more details of the problem...
I need the rates for local as well as foreigners should filter separately in the sub form of memo window...

pls get me a solution for this part of the database...

fox

[June7]

See other thread: https://www.accessforums.net/forms/f...orm-14073.html