Does anyone know databases?

[lizzie_and_ari]

 Hello. I'm trying to build a database. I have been up since six and am at the stage of throwing the computer at the cat, hence killing two birds with one stone.

I have mostly created the database - in OpenOffice Base - and it's good. However, I'm trying to put in subinformation, so each record would look like ( for example);

LJ USER NAME          REAL NAME         ADDRESS     WEBSITE
PHONE NUMBER      MOBILE

(all being unique info), and then:

Post title     Post date      Post rating      User pic
Bees!          27/1/11                3/5                   bee
Wasps!       23/1/11                2/5                 chips
Elephants  20/1/11                4/5                  Map 
So that there is tabular information at the bottom, but that this information is unique to each record. At the moment I've done it so it looks exactly how I'd expected - with a subform at the bottom, but when I go into the next record, the information from the bottom table is in that record, too. That's not what I want!

Does anyone know what I can do?

Thank you.

Comments

[poisonduk.livejournal.com]

A picture tells a thousand stories - can you email me a print screen of what you are seeing at present? Databases are my what I'm paid to support although I'm a wee bitty more used to large scale ones. My home email address is (myfirstname).clark@btopenworld.com - you can also add me on MSN if you want?

[call-waiting.livejournal.com]

I know nothing about Open Office's db, but it sounds like what you want is a join of two tables, and each row of your second table has to refer (by a key, such as the lj username) to the right record in the first table... if you can do that sort of thing in OOo... which I should hope you can.

[lizzie-and-ari.livejournal.com]

Hmm yes that's basically what Jackie said.

I sort of see what you're saying but have no idea, really, how to do it.

I'm at a differentjob now, and don't have Open Office here, but am going to fiddle around with Access on the basis that they are essentially the same.

Thanks x