In my switchlist program (for a model railroad) I have several tables including Locations, Industries, Spots, and Spot Numbers. A Location could have one or more Industries; an Industry could have one or more Spots; each Spot Number has a unique Spot. I'm not sure when clicking on a specific Location how to bring up the associated Industries and Spot Numbers for that Industry only. For example, the Location Crawford has three industries. Each of those Industries has at least one spot number and spot. Example: Crawford Grain Elevator has a spot number 202001 – the spot is Dock; in addition that industry has a spot number 202002 – the spot is Spout. Any help on this is appreciated.
Thanks,
Bob Burke
__._,_.___
Posted by: bburke@swiftaz.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar