time dependent data

[potts]

I need help! I am trying to create a table that stores time-dependent information based on a look-up table.

For example, visit information is stored in a table called visits. Each visit has its own unique ID and contains the name of the visiting person, and the fee they were charged which is obtained from a fees lookup table. The problem is that if the fee changes for future visits, I need the visits table to retain all it's original information, i.e. the old fee for the previous visits.

Can any of you help me out??

 

[BLeslie88]

On right track...

Your set-up sounds good... When you register a visit you should write the fee to the tables so that you aren't referencing the value from the ID. Historic tables for reporting should reference from ID's unless you want current data. All info that is to remain written in stone for future reference should be written to tables as face values at those times.

Hope this helps....

 

[potts]

time dependent data continued

Thanks for the reply. Is there any way of writing this info so that it is somewhat automated - I really don't want to have to type the value each and every time if at all possible.