Auto Updating Usertable from DBDatasource
Hia all, was hoping you could help me. I'm using a user form created in screen painter. This form is connected to a User Defined Object, which in turn is connected to a Document and Document Lines table.
Form layout is pretty standard with a Code, Item Code and Item Description in header and details in the lines section. The tricky part is that I'm using a Grid instead of a Matrix in the lines section. Now as you know, a grid cannot be data bound so what I do is fill the lines DBDataSource (oForm.DataSources.DBDatasource("My Lines Table") ) with all the data from the grid.
My problem is how to force the form to Add/Update both the Header and the Lines tables using the User Defined object. The User Defined object does include both the Header and Lines tables, and I would have thought that the SDK will automatically pull all the data residing in the datasources through to the User Defined Tables. But this is not the case.
If anyone can help me it would greatly appreciated.