Overclock.net › Forums › Software, Programming and Coding › Coding and Programming › Open Office - One to Many?
New Posts  All Forums:Forum Nav:

Open Office - One to Many?

post #1 of 2
Thread Starter 
Hey,

looking for a way to make a list in an OpenOffice table (HSQL, I'll switch to MySQL and write a Qt front end if needed).

Here's my situation;

I'm constructing a basic stock control system and I need to keep a list of all the transactions made, that includes an individual list of items sold. Here's my problem. I can't have a hundred or so fields in each table for the items sold. Can I have one field and have it link to many records in the items database?

It may not be possible in OpenOffice, but I'd prefer it if it was, otherwise I'll have to start again using MySQL\\PostgreSQL and Python. Yey.

This is semi-urgent. I need to make progress, so if you have any comments, please post them. Rep + given to help!
Studio Machine
(13 items)
 
  
CPUMotherboardGraphicsRAM
Intel Q6600 @ 2.6 Ghz I forget. nVidia 8400 2GB DDR2 
Hard DriveOptical DriveOSMonitor
1x320GB, 1x750GB CD/DVD+-RW Windows Vista Ultimate SP1 & Arch Linux 64bit 19inch Acer X193W 
KeyboardPowerCaseMouse
Logitech UltraSlim Pathetic 350w Cube 2 Quid Bargain Bin Thing 
  hide details  
Reply
Studio Machine
(13 items)
 
  
CPUMotherboardGraphicsRAM
Intel Q6600 @ 2.6 Ghz I forget. nVidia 8400 2GB DDR2 
Hard DriveOptical DriveOSMonitor
1x320GB, 1x750GB CD/DVD+-RW Windows Vista Ultimate SP1 & Arch Linux 64bit 19inch Acer X193W 
KeyboardPowerCaseMouse
Logitech UltraSlim Pathetic 350w Cube 2 Quid Bargain Bin Thing 
  hide details  
Reply
post #2 of 2
Thread Starter 
nvm - found an opensource alternative, shoop.
Studio Machine
(13 items)
 
  
CPUMotherboardGraphicsRAM
Intel Q6600 @ 2.6 Ghz I forget. nVidia 8400 2GB DDR2 
Hard DriveOptical DriveOSMonitor
1x320GB, 1x750GB CD/DVD+-RW Windows Vista Ultimate SP1 & Arch Linux 64bit 19inch Acer X193W 
KeyboardPowerCaseMouse
Logitech UltraSlim Pathetic 350w Cube 2 Quid Bargain Bin Thing 
  hide details  
Reply
Studio Machine
(13 items)
 
  
CPUMotherboardGraphicsRAM
Intel Q6600 @ 2.6 Ghz I forget. nVidia 8400 2GB DDR2 
Hard DriveOptical DriveOSMonitor
1x320GB, 1x750GB CD/DVD+-RW Windows Vista Ultimate SP1 & Arch Linux 64bit 19inch Acer X193W 
KeyboardPowerCaseMouse
Logitech UltraSlim Pathetic 350w Cube 2 Quid Bargain Bin Thing 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Coding and Programming
Overclock.net › Forums › Software, Programming and Coding › Coding and Programming › Open Office - One to Many?