Leo_Polla_Psemata
Registered User.
- Local time
- Today, 05:16
- Joined
- Mar 24, 2014
- Messages
- 364
Hi
This is about making offers to customers (shipping, dealing with freight)
I have two linked tables/form.subform, which i use for creating offers to my clients.
In the form, there is combo box from which i chose the area, for example LATAM (= Latin America) or FET (far east) or TAT (trans atlantic) and so on.
There are around 18 different areas.
Now, for each area, there are different elements-freight surcharges that i have to bring in my quotation and fill with rates.
For example
If the area is FET then there are four surcharges (oft/faf/doc/hcs)
If the area is TAT thn there are eight different surcharges i have to fill in (oft/buc/psc/pss/thc and so on)
If the area is EXW then a different group of surcharges (oft/faf/buc).
Each one of these 18 different areas, uses different number of surcharges.
It is a real headache to make sure each time, i haven't forgotten any surcharge line.
Question, is there any method from which, once i chose a code (the area) from combo box,
then, i find in subform listed all the surcharges ready to fill in with rates ?
Subform view is Datasheet
This is about making offers to customers (shipping, dealing with freight)
I have two linked tables/form.subform, which i use for creating offers to my clients.
In the form, there is combo box from which i chose the area, for example LATAM (= Latin America) or FET (far east) or TAT (trans atlantic) and so on.
There are around 18 different areas.
Now, for each area, there are different elements-freight surcharges that i have to bring in my quotation and fill with rates.
For example
If the area is FET then there are four surcharges (oft/faf/doc/hcs)
If the area is TAT thn there are eight different surcharges i have to fill in (oft/buc/psc/pss/thc and so on)
If the area is EXW then a different group of surcharges (oft/faf/buc).
Each one of these 18 different areas, uses different number of surcharges.
It is a real headache to make sure each time, i haven't forgotten any surcharge line.
Question, is there any method from which, once i chose a code (the area) from combo box,
then, i find in subform listed all the surcharges ready to fill in with rates ?
Subform view is Datasheet