Newbies FMJoey Posted March 14, 2004 Newbies Share Posted March 14, 2004 I have two db files, one for Invoices, one for Products. In the invoice file I have a repeating field (Item No's) formatted as a pop-up list of related values from the product db field "Item No's". In the Product db I have 3 fields for 3 different price breaks for each record. I am trying to make a calculation in the Invoice file that will determine the correct price break based on the qty entered for each product listed in the repetition. Any calculation I make only works for the first line in the repetition, every line below will get the same pricing data from the first repetitions record even if it is a different record. I've tried using the extend function with no success. Am I wasting my time trying to make this work? Is there a better solution? Please help!! Version: v5.x [bPlatform: Windows 2000 Link to comment Share on other sites More sharing options...
BobWeaver Posted March 14, 2004 Share Posted March 14, 2004 That is one of the many problems with repeating fields. You should dump them and use a relational design instead with a portal to a line items file. Each invoice item is then a separate record in the related file. Life will be much easier. Link to comment Share on other sites More sharing options...
Newbies FMJoey Posted March 14, 2004 Author Newbies Share Posted March 14, 2004 Ahhh yes, I see the light! Many thanks! Looks like its back to the drawing board! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7347 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