G
Guest
Hello.
I have a form that I use for keeping track of my import, and it includes
boatnames in wich the shipments are loaded on to, when they depart, arrive
port and when they arrive warehouse.
There can be several shipments from different suppliers that comes with the
same boat.
They all, since they are different shipments, have different ID´s.
When I first get information from supplier about when the boat departs and
arrives (estimated), I put that information in the form.
When I later get a confirmation from the forwarder with exact departure and
arrivaltime for a shipment, I now have to find all the shipments regarding
that boat, and change them one at a time.
I know I could make some sort of query, but I prefer the advanced solution,
hehe.
Hoping there is a way to change so I can change them all at once to save time.
There is actually quite alot of them, so it takes a while.
It is also the risk of not having correct information, and I don´t want that.
Formname, as well as tablename is
Import
Relevant fieldnames are
SID (shipment ID)
BoatName
ETD (Departure)
ETA (Arrival port)
ArriveWarehouse
What I would like to do, is to be able to choose if I want to update ETD and
ETA only for the current post, or all posts at the same time where BoatName
is the same as the current post and where the field ArriveWarehouse is Null.
IOW, when I get the information from the supplier, I only want to change the
current post, but when I get confirmation from forwarder I want to change
them all at once just by changing one of them.
Eventually there are som more fields that I want to include in this, but I
guess I can fix that myself if I only know how to do it.
Does anyone have any idea how to solve this?
BR
Claes
I have a form that I use for keeping track of my import, and it includes
boatnames in wich the shipments are loaded on to, when they depart, arrive
port and when they arrive warehouse.
There can be several shipments from different suppliers that comes with the
same boat.
They all, since they are different shipments, have different ID´s.
When I first get information from supplier about when the boat departs and
arrives (estimated), I put that information in the form.
When I later get a confirmation from the forwarder with exact departure and
arrivaltime for a shipment, I now have to find all the shipments regarding
that boat, and change them one at a time.
I know I could make some sort of query, but I prefer the advanced solution,
hehe.
Hoping there is a way to change so I can change them all at once to save time.
There is actually quite alot of them, so it takes a while.
It is also the risk of not having correct information, and I don´t want that.
Formname, as well as tablename is
Import
Relevant fieldnames are
SID (shipment ID)
BoatName
ETD (Departure)
ETA (Arrival port)
ArriveWarehouse
What I would like to do, is to be able to choose if I want to update ETD and
ETA only for the current post, or all posts at the same time where BoatName
is the same as the current post and where the field ArriveWarehouse is Null.
IOW, when I get the information from the supplier, I only want to change the
current post, but when I get confirmation from forwarder I want to change
them all at once just by changing one of them.
Eventually there are som more fields that I want to include in this, but I
guess I can fix that myself if I only know how to do it.
Does anyone have any idea how to solve this?
BR
Claes