How to call information from one table in two spots

[inneed]

Please help!!

I am creating a program that will allow the user to select a sale and pull up only those product items associated to that sale in the details. Any help would be appreciated. Then with in the details section the user will/should be able to enter in the Quantity needed to order. Any suggestions on how to do this. My tblSale does provide the data needed so how do I get the data to go to the form?

I am new to this forum so if I have not asked properly I apologise now.

The Database is attached. Form Orders is the form that I am using to accomplish my task. The getproducts4Sale Query is the information needed.

 

[Pat Hartman]

I don't have time to look at your database. From your description it sounds like your tables are not correctly designed. Take a look at the Northwind database that comes with each edition of Access. It is a sample of an order entry application and will have forms that show you how your application should be designed.