Technique for Creating A Shoping Cart
I'm essentially trying to create a FM database that will allow me to pick from a large list of items we have available for sale, enter in a quantity, and then have that item show up as Item 1 on a quote that we might send to a customer. I'd then like to go back and do the same thing for Items 2, 3, 4, etc. until I've quoted all the items necessary (it could be 1 line item or 100+), then sum up the total and print out a "quote" to send the customer.
I have no problem figuring out how to get a list of all the possible items we have to offer in a quote into a FM data base, but I can't for the life of me figure out how to create that "listing" of items 1 through 100+ that I can show on a quote to a customer. Any suggestions, ideas, or examples from the experienced users that monitor this forum would be appreciated.