Jim Carr Posted July 11, 2001 Share Posted July 11, 2001 Maybe this is a simpler way, but I still can't figure out how to do it: See my earlier post below for the repeating fields attempt. I want to list multiple items and quantities sold on an invoice record. Let's just use multiple fields on the invoice instead of repeating fields as I tried earlier: Item 1, Item 1 Qty Item 2, Item 2 Qty Item 3, Item 3 Qty ... Item 25, Item 25 Qty Various part numbers will be entered into one or more the 25 Item X fields, and various quantities into their corresponding Item X Qty fields. Easy enough. But next I want to view and total up, in another database, a subset of these quantity fields based on the contents of their companion index field, Item X. If and only if Item X contains a certain part number, then I want to list the adjacent Item X Qty from that record (Invoice). Then on the next line of the portal for the next found record, where an Item X field was found to contain the part number, same thing. I get a nice list of "withdrawals" for that part number, based on the invoice activity. In other words, I want my portal relationship to deliver me not just a subset of records but to further search through and deliver to me only the LINE ITEMS -- subsets of fields based on the contents of the index fields. Then I can total up the quantities to get the total of number of these parts ever ordered. Easy enough in a summary, but hard to view in a portal! All I am trying to do is create a live and automatic inventory counter which scans the multiple entries on the invoices in a database for relevant numbers, and adds it up! It sounds so basic. But I am stumped! Come on you guys, It has to be possible! Link to comment Share on other sites More sharing options...
LiveOak Posted July 12, 2001 Share Posted July 12, 2001 See my reply to you other post in this forum. Post a response there to keep the dialog together. Be advised, inventory control systems are among the most complex FM applications, definitely not for the novice! -bd Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7625 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