I'm building a form that tracks cash movements on a day by day basis. A record being defined by the date. I need the closing balance of the prior day(previous record) to automatically populate the opening balance on the current day(current record). I will then use the opening balance to be included in calculations for that days total cash activity.
I'm also having a hard time getting the form control that is based on a calculation of other fields, to show up on a table. i.e. the closing balance is based on a calculation that includes all buys, sells etc.
Any help/suggestions will be greatly appreciated

Hello Friends

I have the following tables:

1. customer- permanent data
customer_code
name
surname
-------------
2. videos - permanent data
video_code
title
type
artist
in/out
-----------
3. borrowing terms - records which vary with time
type
amount
fine_rate
borrowing_period
-------------------
4. borrowed videos - transaction table for reports showing excact transactions
customer_code
video_code
amount
term
dateborrowed
date_returned
fine_rate
-----------------

I want to have permanent transaction records in borrowed _tapes table, the problem is i want to take the borrowing terms fields like amount and fine_rate which change with time as they are at borrowing tme into the transactions table.

May you help me to take a field from one table and insert it into another table eg the borrowing _amount field.

Thanks

SC
------------------------------------------------------------------------

Hello Friends

I have the following tables:

1. customer- permanent data
customer_code
name
surname
-------------
2. videos - permanent data
video_code
title
type
artist
in/out
-----------
3. borrowing terms - records which vary with time
type
amount
fine_rate
borrowing_period
-------------------
4. borrowed videos - transaction table for reports showing excact transactions
customer_code
video_code
amount
term
dateborrowed
date_returned
fine_rate
-----------------

I want to have permanent transaction records in borrowed _tapes table, the problem is i want to take the borrowing terms fields like amount and fine_rate which change with time as they are at borrowing tme into the transactions table.

May you help me to take a field from one table and insert it into another table eg the borrowing _amount field.

Thanks

SC
------------------------------------------------------------------------ rrrrrrrrrr