Changing table name causing problems in layouts
Just created two tables in an existing DB. Did not like the initial names and renamed the tables. When I create a new layout, choosing fields from the newly-named table:
- The layout reports that the fields are referring to a non-existent table, and shows as if I chose fields from a table with the first name,
- Editing the layout to pick the fields from the proper table:
- Does not show the table with the new name.
- The "current table" does refer to the correct table, however, there are no fields show underneath this table.
I think FMP is confused, so am I.
How do I rectify this situation?