Partial payment on event database

S

Sozo

i downloaded the event database, but if a person wants to registure and pay
for more than one person how do you do that? Also, if a person wants to make
part of a payment how do you do that?
 
W

Wayne-I-M

You need to add a table (possible called tblSplitPayments). This new table
need to hold the payment details of "That" payment and details of how much is
attributable to each payee.
Payee1 = £10
Payee2 = £20
Payee3 = £47.89
etc.

Link the splitpayment ID (primary field) with the payee recieved amounts in
a many-to-one relationship.
Don't forget that each payment split has a primary field (Not the actual
amount) and it is this that is linked not the entire amount of the payment.
 
M

Mike Green

Sorry but you are very much mistaken £10 = $18.7160 USD. The exchange rate
obviously fluctuates daily but stays around the £1 = 1.80 mark.

There are loads of online calculators that will show you the latest rate.

Regards

Mike
 
M

Mike Green

Sozo
The exchange rate is approx £1 = $1.80 ish The rate fluctuates daily. You
will need to check the excahnge rate on the day.

Regards

Mike
 
Top