I need some help from the experts designing a A5v10 application before I start heading down the wrong road.
I am starting to design a reporting application for our payroll system (Advanced Micro Solutions� 1099-Etc) to supplement their standard reports. There are multiple clients and multiple years. Overall structure is:
F:\ <<== Payroll drive
1099.w08\ <<== 2008 program directory
MHM\ <<== Client directory
pyd2008.dbf <<== Check table (each record is a separate check, ssn link)
pye2008.dbf <<== Employee info table (employee name, ssn, address, etc)
BHC\ <<== Client directory
pyd2008.dbf <<== Check table (each record is a separate check, ssn link)
pye2008.dbf <<== Employee info table (employee name, ssn, address, etc)
1099.w09\ <<== 2009 program directory
MHM\ <<== Client directory
pyd2009.dbf <<== Check table (each record is a separate check, ssn link)
pye2009.dbf <<== Employee info table (employee name, ssn, address, etc)
BHC\ <<== Client directory
pyd2009.dbf <<== Check table (each record is a separate check, ssn link)
pye2009.dbf <<== Employee info table (employee name, ssn, address, etc)
Normally I need to report by client by year, however, it also would be nice to report by client over multiple years. There is one strange issue: AMS only stores the month and day (12/26) in the check date field so I have to somehow create a new date field which combines the check date field and the year in the file name (12/26/2009).
Any help and thoughts would be greatly appreciated.
Bill Thompson
I am starting to design a reporting application for our payroll system (Advanced Micro Solutions� 1099-Etc) to supplement their standard reports. There are multiple clients and multiple years. Overall structure is:
F:\ <<== Payroll drive
1099.w08\ <<== 2008 program directory
MHM\ <<== Client directory
pyd2008.dbf <<== Check table (each record is a separate check, ssn link)
pye2008.dbf <<== Employee info table (employee name, ssn, address, etc)
BHC\ <<== Client directory
pyd2008.dbf <<== Check table (each record is a separate check, ssn link)
pye2008.dbf <<== Employee info table (employee name, ssn, address, etc)
1099.w09\ <<== 2009 program directory
MHM\ <<== Client directory
pyd2009.dbf <<== Check table (each record is a separate check, ssn link)
pye2009.dbf <<== Employee info table (employee name, ssn, address, etc)
BHC\ <<== Client directory
pyd2009.dbf <<== Check table (each record is a separate check, ssn link)
pye2009.dbf <<== Employee info table (employee name, ssn, address, etc)
Normally I need to report by client by year, however, it also would be nice to report by client over multiple years. There is one strange issue: AMS only stores the month and day (12/26) in the check date field so I have to somehow create a new date field which combines the check date field and the year in the file name (12/26/2009).
Any help and thoughts would be greatly appreciated.
Bill Thompson
Comment