![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
Does anyone know databases?
Jan. 27th, 2011 07:15 am 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.
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.
