Hello. I have created a test table Values1. I have a field in that table that has repeating string values. I am trying to break that field out into its own table with keys etc. (aka normalize).
When I do this with the Analyze Table option under Database Tools, Analyze group, I get "Query input must contain at least one table or query" pop-up.
Here is what I am doing:
1) select table Values1 under tables on the right side "All Access Objects"
2) Click Analyze Table in the ribbon at the top
3) click on Values1 table in the list
4) click next
5) Check "no, i want to decide."
6) click next
7) select, drag, and drop the Report Ccy field out of the default table1
8) Name it RptCcy
9) click next and I get the pop-up "Query input must contain at least one table or query"
Anyone have any suggestions?