This is for an Access project. I am unable to find a foreign key between tables to set up a relational database. So I ended up having the same primary keys for all the tables, which didn't work well when creating queries. here are the tables details, feel free to adjust the tbls orders:
tblDatabaseinfo: ProductBarcode Title Author Price Currency discount etc..
TblStock: ProductBarcode (as primary key as above) Stock Sales Jan Sales Feb etc...