G
Guest
Hello,
I know that the above mentioned is not possible in Access, but what do you
do if that is really what you need?
I have teo tables, lets call them truck and shipments. Each truck has
several shipments on them, so the two tables are related on the truck_id
field.
The guys running these trucks, need a screen wher it is easy to get an
overview of ehich trucks are at their disposal, and at the same time, which
shipments are on each truck. It is no good to look at one truck at a time,
because it is very easy to lose track of the big picture. At the same time,
it is imperative that they can see wher the trucks are going, so that they
can make desicions on where thay are going once they have offloaded
everything.
A listbox in the main form would work as well, but when I try that, all the
trucks seem to have the same shipments on them. I know the reason for this,
but if there is no way around, I am stuck big time.
Does anyone know how I can do this? I prefere a list box over a subform, but
any solution is acceptable as long as the screen shows what I have described
above.
thx
Baard
I know that the above mentioned is not possible in Access, but what do you
do if that is really what you need?
I have teo tables, lets call them truck and shipments. Each truck has
several shipments on them, so the two tables are related on the truck_id
field.
The guys running these trucks, need a screen wher it is easy to get an
overview of ehich trucks are at their disposal, and at the same time, which
shipments are on each truck. It is no good to look at one truck at a time,
because it is very easy to lose track of the big picture. At the same time,
it is imperative that they can see wher the trucks are going, so that they
can make desicions on where thay are going once they have offloaded
everything.
A listbox in the main form would work as well, but when I try that, all the
trucks seem to have the same shipments on them. I know the reason for this,
but if there is no way around, I am stuck big time.
Does anyone know how I can do this? I prefere a list box over a subform, but
any solution is acceptable as long as the screen shows what I have described
above.
thx
Baard