Help With Relationship

[maui]

Please see attached jpg for image I am beginner to FM and need an expert (or novice) to help me. Thanks!

This list displays in a webpage

This list is a portal from 'inventory' table.

User enters qty of each list item but the 'qty' field should reside in 'order' table.

how do I get the qty fields in 'orders' to reside with this list created in 'inventory'

So if user enters '3' of line item one, '6' of line item 4, how do i create a relationship so that my 'order' record will contain the qty's the user has entered based on the line items within 'inventory' table? Currently, the inventory table list you see is a self related

global.

What type of relationship must i create

between 'orders' & 'inventory' so this

may occur?

Thanks!

Edited November 23, 2008 by Guest