Posted: 5/26/2006 6:43:26 AM EDT
|
Disregard, my google-fu finally served me. ie: Table 1 would have three fields; Country, State, and City. When you get to the country field in Table 2 it lists the values of the country field in table 1 (easy lookup). What's getting me is how do you get the state dropdown box to only list values that have the same country as what we have already entered in the country field of the new record in table 2? Thanks |