connecting two tables?

[imintrouble]

Hello,

In my db, I have two tables. They both contain nearly identical information, minus one of them having two extra fields. This second table with extra fields, lets call it Table B, is fed it's data from an Excel sheet, the same which feeds into the other same table, for all intents and purposes with simplicity, let this table be Table A. Table B has exactly ONE query which operates off of itself. This query is supposed to look at a few fields and decide wether to show them or not (Ex: This must be true AND this must be true).

Table A has a form connected to it which lets me input six different options into the table's field which basically says something like, "This is what I, the customer, wish to do."



What I need to do is have a way for me to connect this field from Table A to the same field which is also in Table B so that I can be more precise about which data I want to show in the Query which comes from Table B.

Thanks! I tried to be as simple as possible with my request.

[imintrouble]

never mind, I realized that if I created a relationship between Table A and Table B, then delete the original Query, it would then be possible to simply make a query using the fields from both Table A and Table B. Solved.