Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

using more than one field

Fog
in Relationships

Featured Replies

  • Newbies

I have a database (Sales)that has as one of its fields, part number. Its easy to create a second database (Parts) with part number along with part price. The two databases can then be linked/related so as to get part price and determine charge in the database (Sales) based on number of parts needed and cost per part.

However part prices change. I don't want the previous cost calculations to change everytime I change a price on a part number. Seems to me I need effective dates to be added to the relationship to make the part price current and corrrect. Is that possible? Anybody out there have a solution to this type of problem?

quote:
Originally posted by JL:

I have a database (Sales)that has as one of its fields, part number. Its easy to create a second database (Parts) with part number along with part price. The two databases can then be linked/related so as to get part price and determine charge in the database (Sales) based on number of parts needed and cost per part.

However part prices change. I don't want the previous cost calculations to change everytime I change a price on a part number. Seems to me I need effective dates to be added to the relationship to make the part price current and corrrect. Is that possible? Anybody out there have a solution to this type of problem?

In your Sales database, set the Price field to a lookup using the relationship you describe. Older files will retain the old price that was looked up, while new records will reflect the current price for the part.

Create an account or sign in to comment

https://fmforums.com/topic/3835-using-more-than-one-field/
Go to topic listing

Important Information

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

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.