Spent a very frustrating hour and a half late Wednesday afternoon trying unsuccessfully to get this to work. This is probably the least-intuitive application I have ever used. There is also some trouble now with my account having switched from free trial status to paid, and my acct mgr is trying to figure that out. I'm not a very happy customer right now...
Please explain to me the relationship between the tables I have created for this function. Honestly, I can't even remember anymore how I executed some of this. I intended that CustomerCategory would be a field in the Customer table that would hold the info I wanted, (right now, one of five different descriptions for my donors). In order to enter that information via a dropdown menu, I have ended up creating additional tables - CustomerCategory, CustomerCategoryValues, and CustomerCategoryValues2. Looking at how things are configured in classic/customize/tables&fields, this is what I see:
In the Customers table, CustomerCategory is listed as an existing field formatted as a dropdown.
In the CustomerCategory table, listed existing fields include CustomerCategory (text, unique) and CustomerCategoryValues2 (dropdown). unique) unique & required for table disabled because table has 4 records
In the CustomerCategoryValues table, there is only one field - CustomerCategoryValues (text, required, unique) unique) unique & required for table disabled because table has 5 records
In the CustomerCategoryValues2 table, only one field - CustomerCategoryValues2 (text, required, unique) unique & required for table disabled because table has 5 records
For the sake of clarity, I think I need to delete CustomerCategoryValues2.