Look Up List

[goslincm]

Good morning, I'm working on a table where I have a field called GeneralLongTermDebt. I am finding during data entry in this field I should perhaps have made this a look up field which contains the various funds which could fall under the category General Long Term Debt.

What I need to have happen is, have the user be able to select a fund from the list, enter the fund balance, and then if there are more funds select another, enter its balance and so forth. Then I want all these individual funds to store a total of that overall LongTermDebt fund.

Can this all be done from one field and if so, how?

 

[lespaul]

storing a calculated field breaks normalization rules in most instances. Have you read the fundamentals document linked below?


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[dhookom]

You shouldn't use lookup fields defined in tables

http://www.mvps.org/access/lookupfields.htm.

You can use combo boxes on your forms that allow selection of values from lookup tables.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[goslincm]

Thanks so much for the feedback. Especially the article about the Evils of Look Up fields in tables. I will get to my form and work on an appropriate combo box.