im stupid when it comes to access :rolleyes:

so , i have designed an invoice and i need it to take information from tables and have it placed on the invoice/report.
i have have relationships, tables etc all setup
i have my invoice/report based on a query and i dont know what to search for to make it work, or how to get the information to go on to the invoice.

i have different fields on the invoice and just need the query to search for the information and then display it in the form SIMPLE AS THAT. but it doesnt work :mad:

bit vague, but someone might be able to help, as i know this is something really simple :confused:

would the invoice number pull all the information that you need.

Alastair