maui Posted November 23, 2008 Share Posted November 23, 2008 (edited) 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5775 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now