I have a database with two tables I use for shipping information. One is for if I'm only shipping one item and the other is for a back page of a report for when I ship multiple items. If I'm shipping multiple items, I put SEE REVERSE in the single item block and then enter the rest in a subform linked to the multiple item table. I'm trying to generate a report that lists all items shipped using a tracking number, but when I create a query, I don't...

I created a form based on one table and was able to find information using find record and searching entire form. Now I split the information into two tables: one for the front of a page to be printed and another for the back to be printed. Now when I search for information in the entire form and will only search the record displayed. I'm trying to search the main form and an inserted subform in datasheet view through all records. Please help...