Hi,
here is what i am trying to accomplish:
I have two tables:
customers and complaints
customers table:
Id
Address
Complaint
million other fields etc.
complaint table
address
complaint
some other fields
I need toAFTERinserting record into the Customer table ALSOinsert "address" and "complaint" into the Complaintstable ONLY if "complaint field" was populated in the customer table:
here is my code:
I know it is totally wrong, but i need some directions here on how to solve the issue
----------------------------------------------
'** Insert a record into another table ****
if values("Complaint") is not NULL then
BeforeAdd = true
dim dal_table
set dal_table=dal.Table("Complaints")
dal_table.Employees=values("EmployeeName")
dal_table.Address=values("Address")
dal_table.Complaint=values("Complaint")
dal_table.OwnerID=values("OwnerID")
dal_table.Add()
else
BeforeAdd = false
end if
rsExists.Close : set rsExists = Nothing
-------------------
this is the error:
[font="Arial"][size="2"]Object required[/size]
[font="Arial"][size="2"][size="2"]where i am wrong can someone please help?[/size]
[/size]