2 linked table and one standalone table

[accesslearner]

I have 3 tables

tblprojects
projectid
projectname
tenderid
value


tbltender
tenderid
value

tblleads
leadid
leadcategory
value


tblprojects and tbltender are linked with tenderid and i can create a query to extract the data
tblleads is stand alone and not all leads convert into a tender. there are some leads that have got into a tender but how to link the three values.

end result

i want to see tenders,leads ,projects and sum the values for the corresponding recording monthwise.

how to create a query on 2 linked tables and one unlinked table.

can anyone help .
thanks in advance

 

[Rabbie]

As it stands you will link every Lead record to each and every project and tender record. Are you sure that is what you want?

 

[accesslearner]

Thank you for replying back. Since lead data does not link in any way to project and tender data can i create a table and write the data down month wise and then run a cross tab query. is there any other way to do this
thanks

 

[Rabbie]

You are still going to have the problem that until you tell Access which records to relate to each other it isn't going to be able to match the lead records to the projrct/tender records in a meaningful way.

 

[accesslearner]

you are right how to deal with this. The ultimate result is monthly projects of leads, tenders and projects in the form of a graph.