Hi

I am trying to run an update procedure that updates a total in
tbl_job_card_inventory by multiplying values in the field
tax_percentage from the tbl_settings table. I receive an error and am
unable to figure out how to get aroung this type of query

CREATE TRIGGER ITEM_TOTAL_EXCL FOR TBL_JOB_CARD_INVENTORY
ACTIVE BEFORE INSERT OR UPDATE
POSITION 1
AS
BEGIN
Tbl_Job_Card_Inventory.Total_Incl =
(Tbl_Job_Card_Inventory.Selling_Price -
Tbl_Job_Card_Inventory.Selling_Price*Tbl_Job_Card_Inventory.Item_Discount/100)*Tbl_Job_Card_Inventory.Quantity*(select
tax_percentage from tbl_settings);
END;

Any help would be greatly appreciated. Thanks