How do I format a field in Access 2000 to collect the same data fo

D

dbatts

I need to collect income on the same client for multiple years? How do I do
this without wiping out previous year's data?
 
J

John Vinson

I need to collect income on the same client for multiple years? How do I do
this without wiping out previous year's data?
Click to expand...

By using Access as it is designed - a relational database!

You need (at least) TWO tables - a table of Clients, and a table of
income, related one to many. The client info would go in one table,
and a ClientID and the income information in the second one.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top