How get Unique Records

[Guest]

hiiiiiii hope u all my friends ok ...........
could any body pay attension to my problem , i do hope that they must be
many ...
i have a problem with "Relationship"
i have three tables such as Agent Main table , Agent Amount Paid , supply,

Agent Main Table :- is a table where i have Agent Data such as their address
, contact no , Fax no etc.
Serial No (Number)
Agent_Name (Text)
Agent_ID (Number)
Phone_No (Text)
Fax_No (Text)
Address (Text)

Agent Amount Paid : the table which keep record of the amount paid by
Agent
Sno (Number) // Sno stands for Serial No
Agent_ID (Number)
Date (Date/time)
Payment (Number)

Supply : // Supply Table
Sno (Number)
Agent_ID (Number)
Item (text) // is the items that we supply to them
unit_price (number) // unit price of the items

Note:- there is Agent_Id common in each table and i have Link them with
Relationship though no table consit of Primary key . suppose to be if i
supply 10 items to an agent_ID 100 and he has paid me once so in the querry
for agent_ID
is reapeated for all 10 items that i have supplied .
i need the Unique payment from the agent as it is made or the exact number
of payment that is made i don't want it to be reapeated. though i have tried
the unique table property of the table to but all in van.
hope u may pay attension and will solve my problem
thanks u very much indeed in advance
i wish best of luch................

 

[Guest]

The query needs to have cardinality, meaning it should not be one-to-one,
rather one-to-many. Double-click on the relationship line in the query
design, and select "Include all records from AgentMain and Only those records
from AgentAmountPaid where the joined fields are equal". Do the same for the
other join.

Barry