I have 2 mysql tables I’m working with.
Table 1 has employee information columns :
employee_number
date_of_birth
name
address
etc.
Table 2 has pay information columns :
employee_number (foreign key)
date
bonus
My boss has requested a screen to show the data like, with dates listed horizontally across the top and employee listed vertically :
1/1/2000 1/1/2001 1/1/2002 1/1/2003
Bill $500 $600 $700 $900
Ferdie $300 $500 $800 $434
Tony $450 $234 $432 $343
Can I do something like this through the scriptcase interface?
I’m sure I could do it through SC as a custom app, but is there an easier way?
Thanks