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.

customer 'shows interest' in a product

Featured Replies

I am designing all the standard relationships according to what I have learned. I now need to add another piece and I am not sure how. There are two parts:

1) when we are talking to a customer and if the customer displays 'interest' in one of our products, we want to quickly capture that and I think it should be a related table to Customers or Products. It would just log the timestamp, CustomerID, ProductID. Where would I relate such a table and how could I view a list of over 15,000 products quickly? actually, I think portal with global trigger to filter so I can probably figure this display part out. It is the relationship I question.

2) I have existing excel spreadsheet where I have the CustomerID and then a single note field. It holds things such as

3/17 I called about B8006 and quoted $127.50. 3/22 signed contract on G1182. 6-21-11 told customer that L3022 could be repaired for 27.50.

The bold are StockNumbers. Stock# is a field in my current Products table (along with a ProductID) and I keep it because it is a national cross-reference. I would like to find these stock numbers and then, once I decide how to answer 1) above, 'add records to this new table' for those ProductIDs.

I hope this made sense. Ideas of the best relationship and/or ideas on getting these old stock numbers into new records would be really appreciated. I just sit here and scratch my chin.

Create an account or sign in to comment

Important Information

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

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.