Auto fill a subform based on a common field
In my current database I have all of our customer information and the order information in one table. Every time a customer reorders we create a new record with all of the customer info and the new order info. In my trial with Creator I see that you have a "subform" option which seems like a much better way to handle the information. I split the information and imported it in two different Forms, one for the customers and one for the orders. In the main "Customer" form I added a subform so that I can view all of the orders for that customer. What I want to do is populate the subform based on the address for the customer which is the same as the address for the order. I have tried the lookup fields to no avail, and there is way to much information to retype everything, Any ideas on how to populate the subform?
example: Customer A lives at 123 Main street. There are 5 different orders that have been delivered to 123 Main Street. How do I get those 5 orders to show up in the subform for Customer A?