I have have two tables. Table 1 gives a description of a product. Table 2 has the ordering information on the product.
So I have a query that appends fields from table 2 to table 1. That all works fine. But what I want to do is assign a order number to each group. But when I create a table (in design) I have a mainform that lists order # and Order ID, and then I create a subform, but each record in the mainform shows the same information on the subform. I want the subform to pick up the OrderID number, but it's not doing it. Need some help...please!
So I have a query that appends fields from table 2 to table 1. That all works fine. But what I want to do is assign a order number to each group. But when I create a table (in design) I have a mainform that lists order # and Order ID, and then I create a subform, but each record in the mainform shows the same information on the subform. I want the subform to pick up the OrderID number, but it's not doing it. Need some help...please!