Interactive query without form

[Etrom]

Hi guys,
this is my problem: I have a table Cars with an ID as primary key, where are listed all the cars sold in the last years and then I have another table Components, realated to Cars, where all the components for each car are listed. Here there are also, as foreign keys, the IDs of materials, construction technology and others for each component.
Then I got a table from the sales department with the last sales (hundreds of rows) and I made a query to select the data I need in order to populate the tables Cars and Components. What I want is to check if the materials and other elements in the Components table are present in the material table, in the technology table and so on and, if not, a message should pop up asking me if I want to add the new material, for example, or if I do not allow this material to be used which means I wouldn't add the new material to the table. So far, in order to populate the tables Cars and Components I'm using two different append queries. Is it possible to do this modifying these queries?

Thank you

 

[Rx_]

Lets try to boil the question down.
There are two Append Queries.
Do you need a single parameter (question to pop up) to run both of them?
Or, does some field's result of one append query need to be used to run the 2nd append query?

 

[Etrom]

Lets try to boil the question down.
There are two Append Queries.
Do you need a single parameter (question to pop up) to run both of them?
Or, does some field's result of one append query need to be used to run the 2nd append query?

Thanks for the reply.
I have 2 append query, one to populate Cars table and one to populate Components table. Let's say that I'll start them with a macro, at first I start the one to populate Cars and then the other. Both of them have some field that I would like to check. They contain IDs referring to other tables (let's call them MasterTables) and if the ID is not present in these MasterTables, then I want the system to ask me if there is a mistake or if I want to add that data to the MasterTables so that I can refer to that from the Cars table or Component table