Locking fields linked to other tables

Tech-Archive recommends: Speed Up your PC by fixing your registry

I have a form which captures details of a trade. It uses details from a
Client table dependant on the client selected, such as commission rate and
interest rate. These rates can change over time though but I need it so that
after a trade has been closed ie all the details entered, the rates should
stay as they were at the time of closing. I need to be able to change the
rates in the Client table so that future trades will use the up to date rates.


Sorry if this is unclear! I really need to get this working asap so if any
one could help itd be much appreciated!
.

Relevant Pages

  • Re: Locking fields linked to other tables
    ... Rates table with criteria so that the date the trade is closed matches the ... >amounts which are dependent on the variable commission and interest ... >enter a new record for that client into the Rates table. ... >the correct rate depending on the date of the transaction. ...
    (microsoft.public.access.forms)
  • RE: HELP !!! SUMIF or SUMPRODUCT
    ... i.e Client X 5th Jan $75,000 300 miles ... miles earned by the client over the trade dates, Not to re-sum all the volume ... Accept the defaults for data range (Excel data in the highlighted ...
    (microsoft.public.excel.misc)
  • Re: Locking fields linked to other tables
    ... I can't comment specifically without more details of the data you are working with, but the trade amounts which are dependent on the variable commission and interest rates should be saved in the Trades table, so you may need to add some fields to the table for this purpose. ... Remove the fields in the Client table for the commission and interest etc, and put this information in the related Rates table, along with a date field when the rate became current, and then when there is a rate change, you enter a new record for that client into the Rates table. ...
    (microsoft.public.access.forms)
  • daily interest calculation
    ... database is attempting to capture details of a stock broker's dealings. ... have a "client" table containing contact details for each client. ... USD Commission claire 0.04 21/1/06 ... I think I know how to theoretically calculate the total interest for a trade ...
    (microsoft.public.access.forms)