I have a script importing data from an Excel spreadsheet. When I define which spreadsheet cells import into which FMPro fields despite only having one Table within the database the list of fields available isn't the same but an older version. How do I get it to update to the current one.
I've attached screenshots showing...
Fig 1 is of the defined Table within the database.
Fig 2 showing the field is in the list of defined fields in the database but doesn't show in Fig 3
Fig 3 the list of fields available to import to but it seems to be an earlier version of the Table as it doesn't have the field ama_cd_mindep.