Data transfer from ooBase to ooCalc

new1 · Newbie Joined: 21 Feb 2011 Posts: 1

Hello,

I've searched many topics and found informations which don't satisfy me.
I want to transfer data from TableA to CalcReport by picking IDNUMBER from the combobox (Primary key in TableA) so that rest of the cells in calc will fill automatically!

Name || Surname || Address || Tel || IDNUMBER
Table A: Walt || Kowalski || LA || 200300 || LA19601230
John || Smith || Chicago || 223344 || CO19530512

IDNUMBER || Name || Surname || Addresss || Tel || Qty || Sum
CalcReport: LA19601230 || Const || Const || Const || Const || Custom || Custom
CO19530512|| Const || Const || Const || Const || Custom || Custom

Const values - from table
Custom - normally typed by me

Cheers and thank You for further replies!

Villeroy · Posted: Mon Feb 21, 2011 7:11 am Post subject:

http://user.services.openoffice.org/en/forum/viewtopic.php?t=21099&p=96427#p96427
works with a list box as well.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

Villeroy · Posted: Thu Feb 24, 2011 11:14 pm Post subject:

And yesterday's code importing all tables of a database (any type of):
http://user.services.openoffice.org/en/forum/viewtopic.php?f=20&t=38587&p=177673#p177673
Change c.s.s.s.DataImportMode.TABLE to something else in order to import a query.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org