Query to show outstanding documents

[AccessFreak]

Hi there

I am designing a database for a Visa and Passport company which will manage the companies applications for visas and passports, etc

I have a table for clients info, application info, documents required for the application, and docs received for the application

Now I need to create a query which sums up which docs are required for each application, and which have been received in order to establish which docs are still outstanding.

At the moment (not sure if correct way of doing it)
I have a lookup field in my applications table which I can tick / select multiple values from my DOCS REQUIRED table,

then also in my application table, I have another lookup field which I can tick / select values from my DOCS RECEIVED table

Please tell me if there is any other info which you require in order to assist me



Thank you so much

Mel

[June7]

I won't use multi-value fields. They don't comply with data normalization principles. May be nice for data entry but makes sorting, filtering, searching virtually impossible without complex code. A separate Yes/No field (for received status) for each document would be better than multi-value field although still not quite full normalization but at least I can deal with it.