Jim Carr Posted July 11, 2001 Share Posted July 11, 2001 In a parts sales operation, I have an Invoices database with repeating fields for Item No, Description, Quantity ordered, and Price arranged straight across as line items. Customers typically order numerous line items per invoice. In a related inventory control database, containing a tracking record for each part, I want to view in a portal only Invoice line items (especially quantities) matching a given Item no. I made a portal to the Invoices database, related by the matching item numbers. It successfully turns up all invoices mentioning a given item number. Non-repeating fields list fine: Date, Customer name, etc. Now the hard part: In the portal, from the repeating fields on the invoice, I need to view only repetitions of the line item fields corresponding to the part no. Of course, this part number turns up at a different line, or repetition, on every invoice where it appears. Say an invoice lists some Item 99998s sold at repetition 7 of the Item No field. Another invoice shows some 99998s sold at repetition 3. The info I want to view in the inventory database portal, then, is in the repetitions 7 and 3 of the Quantity Ordered field. I want to list those specific repetitions and only those repetitions. But I can't find any function which return to me the repetition number of the found item number. How can I make Filemaker pick out and list only relevant line items (repetitions) to display in the inventory portal? I realize that a relational database would be the ideal way to view this info, but I can hardly send out a separate invoice for every part on a customer's list. They HAVE to all be on one invoice. This means doing something with repeating fields. Thanks for your help! Link to comment Share on other sites More sharing options...
This topic is 7925 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 account
Already have an account? Sign in here.Sign In Now