I Am New Convert To Alpha5 From Alpha4. Having Used Alpha4 For About Fifteen Years (a4v4 Through A4v8)
In A4, A Parent Db Linked To A Child Db In A Set, Can Summarize A Num Field In Child Database Or A Numeric Summary Can Also Appear As A Logical Field. I Used Both Under Different Circumstances. The Example In Alpha Sports Seems To Be A Logical Field Only.
In Alpha5v8 I Have Structured A Payroll Set, Linking "employee" As Parent To A Child Table "payroll".
A Field In Parent (employee) Has A Num Field " Salary_total",
A Corresponding Field In Child Db Is Named "gross_salary".
I Need To Summarize "gross_salary" And Have The Parent Num Field "salary_total" Collect Or Capture The Data In That Particular Field. I Searched For Specific Help On This But Have Not Been Able To Find It.
Also In This "payroll" Table, I Need Once A Week To Update Two Fields..
The First Is A "pay_date" Date Field And The Second Is A character field "check_nbr" . Both Require User Input..
In Alpha4, I Created 2 Scripts That Used The "waitkey" Command Allowing User To Insert A Date In One Script And A Starting Check Number In The Second Script.
In Alpha5 I Have Played With Both Of These As Buttons On The Weekly Payroll Form.
The Date Works If I Use The Expression {date + 7}, But I Am Unhappy With This Clumsy Solution.
In Alpha5, Can These Be Combined In One Expression And Be Processed At The Same Time??
Would Greatly Appreciate Resolving These Matters.
John Linley
In A4, A Parent Db Linked To A Child Db In A Set, Can Summarize A Num Field In Child Database Or A Numeric Summary Can Also Appear As A Logical Field. I Used Both Under Different Circumstances. The Example In Alpha Sports Seems To Be A Logical Field Only.
In Alpha5v8 I Have Structured A Payroll Set, Linking "employee" As Parent To A Child Table "payroll".
A Field In Parent (employee) Has A Num Field " Salary_total",
A Corresponding Field In Child Db Is Named "gross_salary".
I Need To Summarize "gross_salary" And Have The Parent Num Field "salary_total" Collect Or Capture The Data In That Particular Field. I Searched For Specific Help On This But Have Not Been Able To Find It.
Also In This "payroll" Table, I Need Once A Week To Update Two Fields..
The First Is A "pay_date" Date Field And The Second Is A character field "check_nbr" . Both Require User Input..
In Alpha4, I Created 2 Scripts That Used The "waitkey" Command Allowing User To Insert A Date In One Script And A Starting Check Number In The Second Script.
In Alpha5 I Have Played With Both Of These As Buttons On The Weekly Payroll Form.
The Date Works If I Use The Expression {date + 7}, But I Am Unhappy With This Clumsy Solution.
In Alpha5, Can These Be Combined In One Expression And Be Processed At The Same Time??
Would Greatly Appreciate Resolving These Matters.
John Linley
Comment