Hey! I’m new to libreoffice base & relational databases. I have created a database and two tables: products and specs, and have created a relationship between product ID (primary key) on the products table and specs ID on the specs table. The query seems to be working fine but values from (primary key) product ID does not display on the (foreign key) products ID column on specs table.
What seems to be the problem?
Open “tbl_specs”. Do you see any value for “Product_ID”?
same idea : Is it possible to change a primary key to be auto_increment in an existing table? - #2 by Hrbrgr
It is already set to auto increment. But I think I was getting it wrong? I am supposed to input correct id values from the primary key into the foreign key for the table with foreign key to maintain accurate data?
Yes, if you don’t find another person to fill the column you have to select the record, wich you wish to link.
.
So YOU place a ProductID in the table tbl_specs and can the use a SQL-JOIN or sub-SELECTS to show data from both tables in one query (SELECT )
.
That’s, why Robert asked about contents of your tbl_specs
