Nested Drop Down Menus and Reports (1 Viewer)

[JCHutchinson]

Hi,

My problem seems pretty complicated but I am sure there is a simple solution that I am unaware of but...

My table "A" has a drop down menu of another table "B" within it. My table "B" also contains a drop Down menu of another table "C".

I would like to build a report with values form table A. I would also like to include values from table C based on the selection of B, that is in A.

I am currently generating my report via a query. I have been trying to play around with the criteria of fields within the query, but have been unable to find what I am looking for.

I Do not know much VBA but will learn quickly. I have experience with Java and Object-Oriented programming, so dealing with C# will not be much of a problem for me.

Like I said, i believe the solution is simple, I am just inexperienced with Access. If there are any threads already related to dealing with this kind of issue then please let me know.

Any help would be much appreciated

Thanks for your time,
JCHutchinson