A report with graphs

[OracleScorpion]

Hi,

I have one main table which pulls information from other tables. In the main table is information and links via autonumbering to the other tables in order to fill in the gaps. Now the problem is on how to pull the necessary information and make a graph of it.

The tables will be put down under in the message.

Anyhow, I have a form in which the user has to choose 3 things and on which basis a report has to be made. I know absolutely nothing on how I best start on this, so I hope someone will be able to help me out.

On the form the user must choose a loadingport, a destinationport and an agent (the form is made and in order, I just need to put the code behind the OK-button). From these choices, a list has to be made with all the information on it (from the Freight list combined with the other tables so the user gets names instead of numbers) and also a graph has to be made (columns) with:
X : date
Y : freight

I know it's not explained well, but I always have problems explaining things in an easy way. Nevertheless I hope someone can help me and give me some tips.

THANK YOU!!



Freight
-------
FreightId
Date
CCId
FFId
AgentId
Vessel
LoadingPortId
DischargePortId
Freight
Fac
Valuta
Comments

Agent
-----
AgentId
Agent

CC
--
CCId
CC

FF
--
FFId
FF

Loading Port
------------
LoadingPortId
LoadingPort

Destination Port
----------------
DestinationPortId
DestinationPort

 

[OracleScorpion]

I already know that I will have to use a query, but am still completely in the blue. I showed the tables which I have and the user gets a screen in which to choose the LoadingPort, DestinationPort and Agent. Agent is not necessary to choose. Out of these choices (and after pushing a button), the user has to get a nice report with all details of the Freight table (but of course instead of eg CCId, has to see CC).

Also a graph has to be shown of these items, but I will figure that out once I get a report out of it.

Can anybody help me please??