John -
you wrote:
Looking at a form to edit Locations and their Spots, you would create an outer form to edit the data from the Locations table. In a subform, use a query that links Industries and Spots, being sure to include all the fields from Spots and any descriptive field that you want to display from Industries, but not the IndustryID. Use a Combo Box control to edit the IndustryID, and use a Row Source that returns the IndustryID and description from the Industries table. Make sure that the Link Master Fields and Link Child Fields properties of the embedded subform are set to LocationID. When you use this form, you should see Locations presented one at a time in the outer form. In the subform, you will see all the assigned Spots along with the Industry assigned to that Spot.
Does that make sense?
I set up the Location table with the subform showing Spot Number, Industry, and Spot Description and I created a query (Spot Description and Industry) but I don't understand how to get the data to show in the subform. I guess I'm not sure about the Combo Box and where to find the Master and Child Fields. The Locations are present one at a time.
I set up the Location table with the subform showing Spot Number, Industry, and Spot Description and I created a query (Spot Description and Industry) but I don't understand how to get the data to show in the subform. I guess I'm not sure about the Combo Box and where to find the Master and Child Fields. The Locations are present one at a time.
Bob
__._,_.___
Posted by: bburke@swiftaz.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (7) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar