Is the only way I can display the records from a one to many relationship on the main form, is by using a sub-form.
Let me explain:
I have three customers, (1, 2 & 3)
I have six hubs associated with these there customers -
cust hub
1 1
1 2
1 3
2 4
2 5
3 6
Now, the easy way to display the customer and the hubs would be to create a form from a query of all customers, and then do a sub form with their correponding hubs.
cust - 1
hub 1
hub 2
hub 3
cust - 2
hub 4
hub 5
cust - 3
hub 6
However, if I build a form from a query of the customers and hubs, (which will create six records), how can I display the same info as above on the main form without using a subform but a tab control instead and also displaying each customer only once, (with the hubs in the tab control).
I'm probably not making sense, but I want to see customer 1 on the main form, and be able to look at my tab control and see the first hub, and be able to advance within the tab control and see the next hub's information and so on, but at the same time, if I am moving forward on the customer, to have it only display once per customer on the main form. As it is now, when advancing through the customers, they display three times for the first, two for the second and once for the third.
I guess I'm trying to learn if creating a subform is the only way i can get the results I want, for with a subform, I see datasheet view of all hubs associated with the customer, instead of one at a time.
Hope someone can help me.