Hi all,
I've been using A4 for many years and built a number of applications for my company, one of which was a divisional breakdown for wages costings.
In A4 the main imput set consisted of 2 databases 1.Week and 2.Hour (there are monthly ones but this will suffice as an example.
The three main linking fields in A4 were TCM_EMP_NO, WEEK_NO & TAX_YR_END. The primary record entered into the week database would link to all the minutes spent on different divisions for a week period for each individual employee, thus Week and Year references were required as the years went by to avoid the wrong records in the child table linking to the parent.
After entering the employee number, week number and year number (all numerical fields) in the week db part of the entry form and then tabbing down to the hour table would alow entry for all that weeks time split details.
Worked like a charm for years and with basic reports would result in single entry into the payroll and accounts programs for each employee giving "to the minute" divisional labour splits.
BUT! conversion to A5 PROBLEM!!!
Copied the 2 DBs (and an emloyee Db used as a lookup) made Week the primay and tried to use a 1 to many link as I had in A4. The common field/expression in A4 was:-
str(TCM_EMP_NO,3,0)+str(WEEK_NO,2,0)+str(TAX_YR_END,2,0)
I have tried numerous ways to vary this in A5, bit it results in an error message.
Wth Just fields added it results in a link that sums the field values and picks up records that match the total!
This must be basic stuff but it has me baffled at the moment!
This is my 1st time on the board, I'm from accross the Pond, your help would be much appreciated.
I've been using A4 for many years and built a number of applications for my company, one of which was a divisional breakdown for wages costings.
In A4 the main imput set consisted of 2 databases 1.Week and 2.Hour (there are monthly ones but this will suffice as an example.
The three main linking fields in A4 were TCM_EMP_NO, WEEK_NO & TAX_YR_END. The primary record entered into the week database would link to all the minutes spent on different divisions for a week period for each individual employee, thus Week and Year references were required as the years went by to avoid the wrong records in the child table linking to the parent.
After entering the employee number, week number and year number (all numerical fields) in the week db part of the entry form and then tabbing down to the hour table would alow entry for all that weeks time split details.
Worked like a charm for years and with basic reports would result in single entry into the payroll and accounts programs for each employee giving "to the minute" divisional labour splits.
BUT! conversion to A5 PROBLEM!!!
Copied the 2 DBs (and an emloyee Db used as a lookup) made Week the primay and tried to use a 1 to many link as I had in A4. The common field/expression in A4 was:-
str(TCM_EMP_NO,3,0)+str(WEEK_NO,2,0)+str(TAX_YR_END,2,0)
I have tried numerous ways to vary this in A5, bit it results in an error message.
Wth Just fields added it results in a link that sums the field values and picks up records that match the total!
This must be basic stuff but it has me baffled at the moment!
This is my 1st time on the board, I'm from accross the Pond, your help would be much appreciated.
Comment