Look up values
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?
Software/Hardware used:
Software/Hardware used:
ASKED:
March 29, 2010 11:09 PM
UPDATED:
March 30, 2010 3:09 PM
Answer Wiki:
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
----------------
To see all answers submitted to the Answer Wiki: View Answer History.
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.