![]() The form can only be created after the “customers” and “orders” tables have both been created. In a form, NOT in a table, is where you can get your drop down boxes. The rest of the answer is to make a FORM. Of course, this would be utterly useless for entering information directly into the “orders” table, because I would have to just type in a number for the customer, and just remember that “customer #65536” is “Bob Jimson”. In the “orders” table I would have a foreign key linked to the primary key of the “customers” table. The actual way to solve what I was attempting is to have a primary key in the “customers” table which would be an integer, not the names. If you understand primary keys, you will easily see that I didn’t understand them at the time. ![]() I wanted a drop down list to show in the “customer” field of the “orders” table, which would concatenate the first and last names of each customer from the “customers” table. I wanted to choose a name (first and last name) out of the “customers” table when inputting data into the “orders” table. ![]() Now, I’ll describe the feature the way I imagined it, before I knew anything about databases. If you are kind of fuzzy on understanding those, or don’t instantly know exactly what they are and what is the difference between them, read this tutorial until you get enough theoretical background. Let me explain:įirst, you should understand “primary keys” and “foreign keys”. It doesn’t exist, but there is a better way to accomplish the same thing. The date will be fetched from the database and displayed in Open Office or LibreOffice, respectively.I remember when I first looked into Base, before I had any real knowledge of the theory of databases, and I looked for the feature you’re looking for. To create an SQL query, click Queries in the Database pane, then click Create Query in SQL View…Įnter your query in the query text box and click Run Query (F5).To view the data from a specific table, double-click the table name. When the database opens, you will see the list of tables from your data source diplayed in OpenOffice or LibreOffice Base workspace.You will be prompted to give a name to your new database and select the directory where you want to store it. You can keep the default selection in this dialog box and click Finish.If you have entered valid credentials, you will see a success message. To test the connection to your data source, click Test Connection, input your credentials and click OK. Alternatively, you can specify these parameters in the data source settings of your ODBC Driver for InterBase and leave these fields empty in Database Wizard. If you are connecting to a password protected database, check the Password required field. If your database requires a user name, type it into the User name field.ODBC Driver for InterBase, or you can click Browse, double-click the data source you need, and then click Next. You can either type the name of your data source into the field, e.g. Specify the name of the data source you want to connect to.In the Database Wizard dialog box, click Connect to an existing database, select ODBC from the drop-down list, and click Next.Start OpenOffice or LibreOffice, click Database to open the Database Wizard.Īlternatively, you can launch the Database Wizard from OpenOffice or LibreOffice Calc, Writer or any other tool by choosing File > New > Database.To connect to an ODBC data source from OpenOffice or LibreOffice using our driver for InterBase, perform the steps below: To get rid of the error message, set up the 32-bit version of the driver. Note that the Windows version of OpenOffice is 32-bit, and you may get the error “The specified DSN contains an architecture mismatch between the Driver and Application” when trying to access a data source through a 64-bit ODBC driver. You can access InterBase data from Open Office Base or LibreOffice Base - desktop database management systems. The article describes how to use Apache OpenOffice and LibreOffice to access ODBC data sources using the respective driver. Connecting to InterBase from OpenOffice and LibreOffice using ODBC Driver for InterBase
0 Comments
Leave a Reply. |