Major report - expert advise required please

[BV2312]

Hi all

I need some help on creating a report for my asset system please

Intro:

I have 5 tables:

Client (client_id, name etc)
Collection (client_id, collection_date)
Asset (client_id, collection_date, serial_number, asset_tag, asset_type,
make, model etc....)
Computer (Serial_number, cpu_name, cpu_speed etc)
Monitor (serial_number, monitor_type, monitor_size)

Relationships:

Client to collection is 1:M
Collection to Asset is 1:M
Asset to Computer is 1:1 (using serial number)
Asset to Monitor is 1:1 (using serial number)

I would like to create a report where it would be possible for me to be able
to see:

Client Id and Collection date then all asset of the client_id,
collection_date in asset that has a link to computers and then same for
monitors...

Which way would it be easy for me to create it (wizard/manual)

I would be grateful for someone to help me please


This is how i would like it to look:

Client_id
Collection date (as clients could have many collections)
Asset:Computer
Serial_No, Make, Model, Cpu_name, Cpu_speed etc
Asset:Monitor
Serial_No, Make, Model, Monitor_type, Monitor_size etc

Regards