Blue
White
Purple
Green
Red
Orange
Blue Light
White Light
Purple Light
Green Light
Red Light
Orange Light
When adding a new record, I need to send some of the form data to a second table. I am using:Dim dictSet dict = valuesset dal_table=dal.Table("Jobs")dal_table.JobNumber=dict("JobID")dal_table.Jobname=dict("Item1")dal_table.CostCenter=dict("CostCenter")dal_table.Add()But the submission results in:Microsoft VBScript runtime error '800a01a8'Object required: 'dal.Table(...)'
Make sure that table "Jobs" is the part of the project. DAL is only generated for project tables.
Thanks. That solved it.