I made table for Inventory transactions and inventory, and to make users life easyer, I thought to make form or query with only item, quantity and filter according to whitch item field will be populated, and capturers can insert quantity in order to record inventory quantity status. I was wandering, how I can open form, select filter, and auto populate item field.
What I descovered yesterday is, that what I wanted to do is actually possible in query's; and I actually managed to do something. My initial problem was, I did not use carefully ID's, and relationships were not accheived properly because of that. Lets see, how is going to progress, else I am going to post some more concrete questions. Thanks again for the reply.