Form with multiple variables

  • Thread starter Thread starter RiRi
  • Start date Start date
R

RiRi

HI,
I am stuck.
I have a form in which there are 3 variables (inbound/outbound shipment,
code of service of the shipment, Client)
The combinations of these 3 variables should show me only the correct rate
on the form, from which I can go on and invoice...
So the rate is a combination of the above variables.
The variables are part of 3 tables....
How do I do that?


R
 
RiRi,
I'm not sure that you're dealing with variables. It sounds like you
have 3 individual field values in a table that you need to "join" together
to form some sort of an InvoiceNo?
Please provide some example values of your field values, and show us
what you want to do with those values.
"This is what I have... and this is what I'd like to see."
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Thank you Al, I will try to explain.
The purpose of the database is invoicing shipments to our clients (possibly
in future keeping record of what we were invoiced by suppliers).
The Rate of invoicing depends on 5 variables:
1 - Cycle (we have 2 cycles per year: summer and winter and they are
identified like this: "IS08" is summer 2008, "IW08" is winter 2008, "IS09"
is summer 2009, "IW09" is winter 2009 and so on.)
2 - Client (every client has different rate we invoice)
3 - Code of shipment ( we have 5 types of shipments i.e. baggages, freight
in containers etc. and everyone has different rate)
4 - In or Out (if the shipment is delivered or picked up)
5 - Some types of shipments have a specific rate based on Density of the
shipment itself
Therefore a specifi rate is based on the combination of the above variables.
So I have a table with the shipment information (name, customer, weight,
type of shipment etc)
I created a form that displays the table info.
From the info we input on this form were I indicate all the variables
indicated above, I would like to have the specific rate on the form for the
final invoicing.
I have codes for clients:
AAAA
AAAB
AAAC
etc
I have codes for the shipments; 5,8 7, T, J
I have codes for the cycles: IS08 (current)
I have codes for "Inbound" or "Outbound" Shipment in or out.
Density is done by Net weight of the shipment divided by Cubic footage.

I have a table were I indicate the rates as following:
Cycle Client Type of shipment Rate 4
Rate J Rate 7 Rate 8 Rate T
IS08 AAAA Inbound 0.00
0.00 0.00 0.00 0.00
IS08 AAAA Outbound 0.00
0.00 0.00 0.00 0.00

And so on.
I still have not figured out the density variable thoug...


Sorry for the long post

R
 
RiRi,
Given the data you presented...
You wrote...
Therefore a specific rate is based on the combination of the
Click to expand...
above variables.

What combination? You haven't indicated how you caclulate
your 5 pricing schemes.
How do you calculate Rate4... as opposed to RateJ... etc...
from the field values you showed for Cycle, Client, and ShipCode?
Those "text" values may influence the pricing, but without a pricing
formula for 5,8 7, T, and J rates... I have no idea.

You wrote...
Density is done by Net weight of the shipment divided by Cubic footage.
Click to expand...

Now this is a "formula" I can understand.
But, where are those values in your Invioce?
It would seem to me that you should have values indicated in your Invoice
for NetWeight, Length, Width, and Height values. Then the calculation would
be...
Density = NetWeight / (Length * Width * Height)

If you're asking for help in calculating different pricing structures, we
need to know the formulas for each, and sample values involved.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Al,
I am sorry I was not able to explain myself correctly, I have some speach
impairment...
Please forgive me.

However I was able to use some of the Synchro combos feature.
But I am stuck again.
I will try to explain where I am blocked now.
I have 1 table made of this fields (open full window) that contains the
rates (per 100 lbs)which are preestablished with the clients:
Cycle Client In or Out Area
Shipment_code_4 Shipment_code_J Shipment_code_8
Shipment_code_T Shipment_code_7
IS08 AAAA In Germany $
10.00 $ 11.00 $ 12.00
$ 13.00 $ 14.00
IS08 AAAA In England $
20.00 $ 21.00 $ 22.00
$ 23.00 $ 24.00
IS08 AAAA Out Germany $
30.00 $ 41.00 $ 42.00
$ 33.00 $ 34.00
IS08 AAAB In Belgium $
50.00 $ 51.00 $ 52.00
$ 53.00 $ 54.00
and so on.


From the main form (shipment) I am able to have 4 synch-comboboxes that
filter the choices from the table (and behind the scene input in the
Shipment main table for calculations)
1) Cycle combo box that filters:
2) Client combo box that filters:
3) In or Out combo box that filters:
4) Area combo box
Here I am stuck:
the last step would be display (and possibly record on the shipment table)
the pre-established rate filtered by the combos for that specific Shipment
code.
If the shipment is a code 4, I would need to have displayed the
shipment_code_4.
How do I do that?

Thanks,
R
 
RiRi,
I'm really sorry RiRi, but I just can not understand what you're trying
to do exactly.
Let me try this...
Perhaps you're trying to get the ShippingCode values from a combo box,
as you "drill down" through your series of synched combos.
Let me try an example...

Each product I sell has 3 prices... APrice, BPrice, and CPrice, and each
customer has a field called PricingRate, which can contain an A, or B, or a
C.
I have a combo box (cboPartNo) with these columns...
PartNo APrice BPrice CPrice
1324 1.00 1.25 1.50
6152 2.00 2.35 2.60
7132 5.00 5.50 6.00
.... etc...

This sample customer order involves a customer with a "B" price.
and I then select the 6152 PartNo.

But, I also need to capture the BPrice from the combo, and capture it in
a field on the form called Price.
Given that combo box columns are numbered 0, 1, 2, 3, etc... and that I
have data that says this customer is a "B" customer...
I run some code on the AfterUpdate event of cboPartNo.

Private Sub cboPartNo_AfterUpdate()
If PricingRate = "A" Then
Price = cboPartNo.Column(1)
ElseIf PricingRate = "B" Then
Price = cboPartNo.Column(2)
ElseIf PricingRate = "C" Then
Price = cboPartNo.Column(3)
End if
End Sub

In this case, the Price on my invoice = 2.35

Read up on the combobox Column property, and use it to select the right
price for the right customer PricingRate.
Hope this helps...
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Back
Top