Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

customer 'shows interest' in a product


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

Recommended Posts

Posted

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.

This topic is 4786 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
×
×
  • Create New...

Important Information

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