Use buttons to navigate and open current attachment

[mr_right0406]

Hello.
Good day!
i am new here and beginner in microsoft access.
Just want to ask if it is possible to use buttons to navigate/open attachment?
I have two tables (itemTbl and ItemcomponentTbl) and a form.
Inside formare itemtbl field names (w/c include the attachment) and a componenttbl subform.
Hopefully someone will help me on this.
Thanks in advance.
Here is my DB.

 

[jdraw]

I think your relationships are wrong, but I don't know enough about WHAT your data means to be certain.

You have in ItemTbl (all text fields)
StockNo
IDNo
ProductCode PK

in the Itemcomponents you have no PK
and fields
ProductNo
Items

In a couple of sentences - in plain English - tell us What a Product is and What a component is.

Every table should have a Primary Key.

I have no idea how 1 ProductCode can have 4 different Items

 

[mr_right0406]

Thanks Jdraw for your response.
I use product code to represent each product.
Each product have different components.
This components compose of names, qty, cost, and photos.
StockNo,Idno,productcode - combination of text and number so i use text as data type.