Jump to content

Repeating field relationships


FMJoey
 Share

This topic is 6526 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

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

This topic is 6526 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

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.