There has been a new requirement which collides with current design.
There's a table holding information of Regions. In it is a column for manager of departments within that region + following two - his Telephone and E-mail. Currently, if that manager is male, then his phone and email data have particular text color in all related reports. Likewise, if female, these fields have another text color.
New request is to change form so that you can not only add one manager of department per row, but two separately, one specifically male and another female (something like two separate select lists). It seems to me this will cause a bit of distortion in terms of relational database level. Because report can show Tel and Email based on this column of manager. This will be messed if I add another column which shows one more manager(just different gender). Adding second Tel and Email for second manager seems a bit odd, don't you think?
Otherwise, if I could add both managers through 2 fields within a form, as two rows in a table - and then report would show one row for first manager and another repeating for second - would not be ideal but still better, however it's not possible to write to the same DB column through more than one form item, as I gathered.
Any suggestions? is this requirement reasonable and I'm blind to see a reasonable design solution, or what?
Thanks.