AnsweredAssumed Answered

Different prices based on adress and date of service

Question asked by MAKALENG on Feb 22, 2016
Latest reply on Feb 22, 2016 by bigtom

Hi all

 

i have close to 9 Provinces (states)  Tables (actually 18 cos all 9 provinces have 2015 and 2016 price lists)

each Table has code, description and amount as field names,

code and description is the same on all tables , where they differ is the amount [based on the province(state) and date (Year)of service]

the problem is

i need calculation for Amount field on Invoice to be calculated  by checking on Contact Details Table which state is the customer from and then date of service which year was service renderd and bill them accordingly

 

TABLE 1: NORTH PROVINCE 2015

CODE : 0001 DESCRIPTION: COUNSELLING AMOUNT: 100

 

TABLE 2 IS NORTH PROVINCE 2016

CODE : 0001 DESCRIPTION: TREATMENT AMOUNT: 150

 

TABLE 3 IS SOUTH PROVINCE 2015

CODE : 0001 DESCRIPTION: COUNSELLING AMOUNT: 120

 

TABLE 4 IS SOUTH PROVINCE 2016

CODE : 0001 DESCRIPTION: TREATMENT AMOUNT: 170

 

ALL TABLES ARE ACCORDINGLY RELATED, I STRUGGLE WITH AMOUNT CALCULATION

Outcomes