I have two combo boxes on a form. Each one has data that comes from a seperate table. The two tables have a one to many relationship related by location_id. How can I make it so that when the user chooses something in the one side of the relationship combo, the many side of the relationship combo populates at that time with only related records?
Any ideas would be appreciated. Thanks.