Look up values

5 pts.
Tags:
Access 2007
look up wizard
I am creating a datbase for a lawyer. Some clients have multiple charges under their name. I have created a look up value for the name of the charges to make the process quicker, but so far I am only able to choose and display one charge. Is their a way to add more charges within the row? does anyone have any suggestions on how I shouls organize the database?

Answer Wiki

Thanks. We'll let you know when a new response is added.

More details would be needed to provide a good answer, but in general, you should have a table to store information of the Clients, one look up table for the charge types, and one table to store the charges to clients, in which you will have one record for each charge to a client.

More tables could be needed depending on the information you want to store for the clients.

With this design, you will probably want to create a form to show client information and a subform to enter the charges for the current client.

-CarlosDL

—————-

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Meandyou
    Carlosdl is absolutely correct. The basis for his answer is First Normal Form - remove repeating columns and create a table for those values. Said another way; make rows, not columns.
    5,220 pointsBadges:
    report
  • Aguet001
    [...] Look up values, asked by Aguet001 and answered by [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following