Product contains product?

Let me start by saying I have barely even started using Zoho Creator. I am trying to verify it will do what I need before investing much time into it. Please forgive me if this is a dumb question :-)

Also, I'm not sure how to even begin searching for this, so I hope this is not a FAQ. It is easy enough to explain, but I'm not sure what to search for. I know I need a lookup, but I need a lookup to the same table.

I sell products, and some of those products are made up of other products. The easy way to visualize it is to think of a company that sells computers. They sell Hard drives, Motherboards, and memory, but they also sell them all put together into a finished product.

I have been trialing Filemaker Pro, and this is the basic structure that works there:

Products Table:
Product_ID
Product_Name
Qty_On_Hand

Product_Components Table
Product_ID   < Product_ID of the parent product
Child_ID       < Product_ID of the Child Product
Child_Qty     < Qty of the Child Product included

I could have two tables, "parts" and "products", but since almost every part is also a product on it's own, it seems to be silly to duplicate the data like that.

Is it possible to set up a relationship like this? If not, are there any good workarounds?

FWIW, In Filemaker you achieve this using what they call "Table Occurrences", which is basically a virtual duplicate of the table. In that way, i effectively am using two tables as far as the relationship goes, but behind the scenes it all points back to the same table (see the attached screenshot).