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.

Re-use same id

georgewash
in Relationships

Featured Replies

I have a need to determine if a customer already exists in the table occurence and if so to use it's original id. Here are the tables:

Customer:

Name

Associate Status

Coupon Codes:

Name:

Associate ID

Coupon $ Amt

Coupon Code

Currently one selects the name in Coupon Codes from those identified in Customers as with a positive Associate Status. The Associate ID is a serial id generated on creation. Then one enters the Coupon $ Amt manually and the Coupon Code is generated by calculation.

The problem is an associate customer can have more than one coupon code, but should retain a constant Associate ID. Obviously the Associate ID can't be a simply serial number.

My thought is an if then statement but I am stumped on how to avoid creating recurvsive problems. I am also unsure on how to test if the Name has already been used.

Thanks.

Place the Associate ID into its own table: Customer

Obviously the Associate ID must be a simply serial number

  • Author

Not sure how that is going to help.

Is there a way to sum all of the customers with Associate status and then add one to the total to create the new ID?

Create an account or sign in to comment

https://fmforums.com/topic/62466-re-use-same-id/
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.