needing one field to sort another from different tables in form

[barrettw4]

I am a BEGINNER!! I am starting a program to input data shipping corn, from multiple origins to multiple destinations. I am trying to figure out a way to enter the origin, and only have the destinations associated with that location to be on a drop down list in the next spot. I have tables of Origins, listing the different locations, destinations table, listing all information about the destinations, along with the loads table that will have all the loads taken.

I am not sure if i need to do this through the form or a different place.


Thank you for your help

[pbaldy]

Sounds like this:

Baldy-Cascading Combos

though on a continuous or datasheet form it gets more complicated.