Product linked and drag another product by picking it at a new Order

[NsTecnicaTyO]

Hi everyone!

I've an issue here, and im stuck. 

I've got an app for a Inventory Database of items. My issue is that when i select a product, we need to automatically select all the products that are linked with the primary product.

How i can link the products in the same table, and how can i select one item, and this item drag the others to a order list?

An example can be: when i pick 'Camera Sony VENICE - s/n: 1111' (as primary product), i need to pick to the order list automatically 'ViewFinder Sony OLed DVF-EL200 - s/n: 2222'

All of this products are in the same table, because we need it in that way. We identify all our items by Serial Number, and by individual parts.

It is understood?

Here i drop some screenshots. 

Inventory

Add product to a new order

new order with the product selected

order details.

Thanks in advance!

[SkrOYC]

Creo que no entiendo muy bien qué requieres.

Podrías tratar de explicar la utilidad de lo que planeas en lugar de cómo lo harías en AppSheet?