By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,472 Members | 1,229 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,472 IT Pros & Developers. It's quick & easy.

Transfering Data: from end of year/season to beginning of next

P: n/a
TABLES

CustomerTable CustomerTarrifTable TarrifTable WarrantTable
CustomerID(P) CustomerTarrifID(P) TarrifNo(P) WarrantID(P)
BoatType QuantityPurchased ProductName WarrantDate
CustomerName Cost QuantitySold
Season Cost
TarrifNo Season
CustomerID TarrifNo

SeasonTable
Season(P)
(P) = Primary Key

Relationships

CustomerTable--->CustomerTarrifTable on CustomerID = onetomany
TarrifTable--->CustomerTarrifTable on TarrifNo = onetomany
TarrifTable--->WarrantTable on TarrifNo = onetomany
SeasonTable--->WarrantTable on Season = onetomany
SeasonTable--->CustomerTarrifTable on Season = onetomany
have set up the previously shown five tables and relationships in a
database for a boat marina to declare what they have bought and sold
to customs.

Each product has a unique number called a tarrifNo.

each time a product is bought from a supplier it is called a warrant
and these are entered during the year.

At the end of the year the purchases made by a customer is entered
into the database.

the totals calculated to see how much is left in stock and the cost of
the items in stock.

At the start of a new season the totals from the previous season are
brought forward.

Is there a way that I can transfer all the data from season 03/04 to
season 04/05 before any other data is entered to the new season? And
so on for each year. Could this be done with the use of a button on a
form perhaps?

Regards

Lloyd
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
> At the start of a new season the totals from the previous season are
brought forward.

Is there a way that I can transfer all the data from season 03/04 to
season 04/05 before any other data is entered to the new season? And
so on for each year. Could this be done with the use of a button on a
form perhaps?

Regards

Lloyd


Sounds like a periodic snapshot... oh, the fun! Sounds like you need
to have a look at Allen Browne's Inventory schema. Sounds like what
you would do is at the end of each season, write the ending totals for
each productID to a new record for the new season. then you can
archive all of the sales data and use the new numbers. Same idea as
when you balance your checkbook - you prove everything balances, then
you carry over your ending balance for last month and it becomes the
beginning balance for the current month.

Could this be done with the use of a button on a form? Umm... yeah, I
guess so. I'd be really careful and make sure everything worked,
though, first. Also, you'd probably want to use transactions to make
sure that you could roll everything back if anything went wrong.
Nov 13 '05 #2

P: n/a
Where would i find allen brownes inventory schema?

pi********@hotmail.com (Pieter Linden) wrote in message news:<bf**************************@posting.google. com>...
At the start of a new season the totals from the previous season are
brought forward.

Is there a way that I can transfer all the data from season 03/04 to
season 04/05 before any other data is entered to the new season? And
so on for each year. Could this be done with the use of a button on a
form perhaps?

Regards

Lloyd


Sounds like a periodic snapshot... oh, the fun! Sounds like you need
to have a look at Allen Browne's Inventory schema. Sounds like what
you would do is at the end of each season, write the ending totals for
each productID to a new record for the new season. then you can
archive all of the sales data and use the new numbers. Same idea as
when you balance your checkbook - you prove everything balances, then
you carry over your ending balance for last month and it becomes the
beginning balance for the current month.

Could this be done with the use of a button on a form? Umm... yeah, I
guess so. I'd be really careful and make sure everything worked,
though, first. Also, you'd probably want to use transactions to make
sure that you could roll everything back if anything went wrong.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.