Newby-Help With Relationships

Hi,

Seems like the more i get into reading the more confused I get in this basic
fundamental. I just need it explained really clear and basic, then hopefully it will enter the subconcious and I will be able to proceed :)

I am trying to build with Access XP in 2000 version a small program for a small medical office.

Patients are offerd various services and they have vists to take advnatage of them. They are charged for the services and run an account which is then paid, leaving a balance.

I want it all to be entered via forms for older non computer literate staff.

I have done the main table okay with all the info we will need and I have messed around with the other 3 tables I think I need.

1. To enter the Services offered a description and fee.
2. Enter when they visit and what services they have and fees with total
3. When they make a payment and balance owing.

They are one to many relationships, correct?

For a start am I on the right track ?

My confusion is setting up the relationships especially what field/s has to be linked to fields in the other tables to make it work.

Is there a rock solid rule where a certain field has to be in each table and has to be linked ?

These are the first fileds in my MAIN TABLE..

Patient ID Auto Number Primary
Medicare Number Can be blank
Last Name Text
First Name Text
Address Text

SERVICE TABLE (Primary?)

Service Type /Combo- Accuncture-Massage-Herbs-Vitamins-Other
Description of Service Text
Charge for Service Text

VISIT (Primary?)

Date and Time of Visit: In case 1+ visits in one day
Reason for Visit

ACCOUNT

Date
Service Charges
Payments
Balance

I know it is basic but I need to get over this block..

Thanks in anticipation of help

Oz

:confused: