[Solved] Insert text in a existent table

Discuss the database features
Post Reply
Hannes58
Posts: 7
Joined: Sat Jul 30, 2016 1:17 pm

[Solved] Insert text in a existent table

Post by Hannes58 »

Hi All,
I have a music database designed by Villaroy (And many thanks for that). But I need 2 lines in the table Media, Disc and Location. I made a lot of MP3 music discs and store them in a rack. To find these music files I need 2 new lines in that table.
Is it possible to expand this table with Disc and Location? Or is it put the text in the table and save it?

How do I create then a new form? If it's necessary.... I think so...

Hannes
Attachments
music.odb
(41.07 KiB) Downloaded 100 times
Last edited by Hagar Delest on Sat Jul 30, 2016 9:46 pm, edited 1 time in total.
Reason: tagged [Solved].
OpenOffice 4.1 on Linux Mint 18
F3K Total
Volunteer
Posts: 1038
Joined: Fri Dec 16, 2011 8:20 pm

Re: Insert text in a existent table

Post by F3K Total »

Hi,
like the attached?
I just added two columns to table Media, then added the necessary controls to the form and bound them to the new columns.
R
Attachments
music.odb
(41.08 KiB) Downloaded 113 times
  • MMove 1.0.6
  • Extension for easy, exact positioning of shapes, pictures, controls, frames ...
  • my current system
  • Windows 10 AOO, LOLinux Mint AOO, LO
Hannes58
Posts: 7
Joined: Sat Jul 30, 2016 1:17 pm

Re: Insert text in a existent table

Post by Hannes58 »

F3K total

Thanks for doing it. It rocks!!!

Hannes
OpenOffice 4.1 on Linux Mint 18
Post Reply