![]() ![]() The first window will be an empty OpenOffice window which will be followed by the wizard window (see Figure 2). Once you have the database selected click the Finish button which will open up the database to the Forms window (see Figure 1).įrom within this window you want to click the "Use Wizard to create form" link in the upper left pane. What you want to do is click "Open an existing database file" and then select the database from the drop-down. If you no longer have that database, follow the steps in the article to create a new one and then come back here.įirst open up OpenOffice Base which will land on the Database Wizard. To do this you will have to go back to that database. In this article I am going to walk you through the process of creating a form in order to enter data into the database you created with the help of the original article. ![]() Oh sure you could connect that new database with MySQL and work your best MySQL magic on the database, but for the masses who aren't MySQL gurus, having a tool that is as simple as creating a form with a Wizard is a boon to working with a Base database. many-to-many (m-n) relation between "Persons" and "Items" through mapping table "Persons_Items".Fortunately OpenOffice Base includes tools to help you add data to your database. Image: one-to-many (1-n) relation between "Prefs" and "Persons". Sometimes you have to restart the whole application. Close and re-open that window in this case. Sometimes it fails to create a valid relation. However, this graphical tool is a little bit awkward. GUI Method -Īdd the two tables side by side and draw a line between the 2 fields. if "TBL_B"."AID" contains values without equivalent value in "TBL_A"."ID". The modification fails with an integrity error if the tables contain data that would violate the key, e.g. The linked fields have to be put in braces because a foreign key can have more than one field on each side.įinally call menu:View>Refresh Tables in order to propagate the modified database to the Base GUI. TBL_A is the 1-side with primary key "ID". "TBL_B" is the many-side of the one-to-many-relation with foreign key "AID". Code: Select all ALTER TABLE "TBL_B" ADD FOREIGN KEY ("AID") REFERENCES "TBL_A"("ID") ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |