Libreoffice Base: Foreign Key column shows up empty

[Dhrub]

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?

[RobertG]

Open “tbl_specs”. Do you see any value for “Product_ID”?

[fpy]

@Dhrub

seems

same idea : Is it possible to change a primary key to be auto_increment in an existing table? - #2 by Hrbrgr

[Dhrub]

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?