List Box?

T

Tom

I have the following:

“DispatchTable
“DispatchFormâ€
“FacilityTableâ€

On the “DispatchFormâ€, I have two areas for inputing
Facility information. One is the Transfering Facility the
Other is the Receiving Facility. I'm hoping to use just the
"FacilityTable" for both.

What I would like to do is have a drop down list under the
Transferring Facility name, that I can choose the Facility from the
“FacilityTableâ€.
After I choose, it automatically puts in the address, city, etc. on the
“DispatchForm†and into the “DispatchTableâ€

Likewise, under the Receiving Facility.

I made a List Box for “Transfering Facility Name, and it works fine, however
when
I do it for the 2nd area, “Receiving Facility Nameâ€, it changes the
“Transferring Facility Nameâ€. I do not know how to do the rest.
What am I doing wrong?

Tom
 
Top