With your current design, your portal can only list records where the description field in Sales matches the hose field. There's no way to select different types of hoses and see them all listed in the same portal.
Seems like you need at least three tables here: Sales Order, Hoses, LineItems.
SalesOrder::OrderID = LineItems::OrderID
LineItems::ItemID = Hoses::ItemID
You'd place a portal to LineItems on your sales order layout and use looked up value field options to look up descriptions, prices from the Hoses table. You'd select an item by selecting its part number from a drop down that uses a value list that displays both part numbers and hose names in two columns.
Using a relationship between lineItems and Hoses that is based on the name field could be done, but it locks you into a specific name or description. Change the name and link breaks.
You might want to examine this demo file uploaded by Comment:
In it, your "hoses" table is named "products".
Thank you it has worked brilliantly many many many thanks!