Relationship Type

[yohan]

I have following tables where Ref No is the unique identifier.

One Reservation can have multiple payments.
One Reservation can have one event manager.
One coordinating report comes from Event Manager for each event.
Final bill is raised after coordinator report comes.



How to make relationship in access and what kind of relationship needed here.

Reservation
	Ref No	Client Name	Event Date	Telephone	Performa Invoice Value		Venue
					Refundabale	Non Refubable
Payment
	Ref No	Client Name	Payment Value
			Refundabale	Non Refubable
Event
	Ref No	Client Name	Event Manger
Coordinator Report
	Ref No	Client Name	Event Date	Submitted Date	Event Manager
Final Bill
	Ref No	Client Name	Final Bill Amount

[orange]

In your tables and description, where are Client, Invoice and Event?

[Micron]

- there should be no Final Bill Amount field. Calculations like this should not be stored.
- don't repeat data (Refundabale, Non Refubable).
- you have a client table? Then no repeating data such as client phone number in other tables.
- event date is not in event table, but in reservation table?
Nor would I repeat the Ref No everywhere. Are you going to try to set up referential integrity and cascade update all these fields if you should have to edit a Ref No entry error? I think you need to reconsider data structure before worrying about relationships. Perhaps these will help
Normalization Parts I, II, III, IV, and V
http://rogersaccessblog.blogspot.ca/...on-part-i.html
and/or
http://holowczak.com/database-normalization/