fund1, fund2, fund3 - repeating field question

[hpoincare]

I have a need to enter an account number nine times in one record. The
account number can be one of 10 accounts.

I know that it's bad practice to have; fund1, fund2, fund3...etc fields in
one table. I'm baffled on how else to enter this?

Can someone familiar with this problem give me some pointers?

Thanks

 

[Jerry Whittle]

You have a table of Funds with an autonumber primary key.

Then your data could look like so:

AcctNo Fund
1234 1
1234 2
1234 4
5678 1
5678 9