I have an access 2003 database. For one field, the user chooses an available case number from a combo box for a client.
The drop down has 4 columns based on the case table so that they case number has some meaning (case ID #, sequential case number for particular client, reason for referral).
I think I have set this up poorly and am looking for advice. Once the case is chosen, it writes that case number to the table for that contact (appointment) but I am left on the screen with a very wide field with a short number in it. This looks odd and unprofessional.
Some ideas I have floating in my head are to write the values of all the fields to the appointment, but this seems like poor database design since this would duplicate info into 2 tables. Another idea I had was to make the size of the field change through code when the user is not choosing a value, but I am not sure how to do this and it sounds like it would look weird to the user.