Sorry if this has been asked and answered but I have looked and can’t see it anywhere. Yes I am a nooby.
I have a DB called Swarm with two tables.
Table 1 is called Area and contains two fields: AreaID (Primary Key), Area
Table 2 is called Collectors and contains five fields: CollectorID (Primary Key), Collector, Landline, Mobile & AreaID (Foreign Key).
There is a 1toM relationship between the Area Table and the collectors table
For example:
Area Table:
areaID / Area
1 / London
2 / Edinburgh
etc
Collectors Table
CollectorID / AreaID / Collector / Landline / Mobile
1 / 1 / Jim Smith / 123456 / 0789097
2 / 2 / Jo Soap / 34567 / 987654
3 / 2 / Bilbo Baggins / 987655/ 897987668
4 / 1 / Peter Jones /89723487634 /o89874
etc
What I would like to do is have a dropdown List of the Areas available (London and Edinburgh in this case). So, if user chooses Area 2 from the Drop Down box it will display all the fields with that areaID in the Collectors Table. So in the above example. If the user chooses Edinburgh then Collectors Jo Soap and Bilbo Baggins will be displayed.
Hope this is clear. I hope you can help. Thanks in advance