History

[jgalloway]

I am trying to find a way to create a history of a wagon.



I have 2 types of customers that can buy a wagon. One is called an Account Manager (AM) and the Second is called a Sales Rep (SR). Only 1 person can own a wagon at one time.

Lets say Simon (AM) purchased a brand new wagon. Simon sells back the wagon to me and I resell this wagon to Jeremy (AM). A few years later I purchase this back from Jeremy. I then resell this wagon to Jason (SR).

I want to see a history of the people who had purchased this wagon over the years.

The design I have 3 tabs on the wagon form. The first tab being the information about the wagon and current owner of the wagon. The second is being the owner history of the wagon. The 3rd being a notes tab.

I am up to any ideas of how to get this to work.

[goodguy]

tblContacts
- ContactID
- ContactName
- ContactGrade

tblWagons
- WagonID
- WagonReg
- WagonModel
- WagonSold (Y/N)
- WagonOtherData

tblTransactions
- TransactionID (PK)
- TransactionType (Sale/Purchase)
- ContactID (FK, LOOKUP)
- WagonID (FK, LOOKUP)
- TransactionDate (DATE)
- TransactionValue (MONEY)

Set up validation on tblTransactions.WagonID so that if it is a sale, only Wagons that are unsold will populate the combo. If it is a purchase, unsold Wagons will be excluded from the combo.

[jgalloway]

Sorry I am very new at this and its a little foreign to me. I guess I am not getting what you are saying really. I think I like the idea of where you are going though.

[jgalloway]

Im up to any ideas.

[goodguy]

My Access fails to open the unzipped accdb file, error: Unrecognized format.