You could set up a script on a timer to use the excel file to update your filemaker file periodically.
How is this set up? Is there a particular script that I'd need to use?
Again, I'm very new to Filemaker and I'm not all that familiar with scripts. I apologize if this has been addressed in other posts.
There are two options that you can research in FileMaker help: A recurring import. This feature allows you to drop an updated copy of your excel file into a folder and FileMaker automatically purges the records from a table and imports a new copy of the data from the excel file. This is fairly simple to set up, but limited.
You can also use Install OnTimer, or a script that runs each time a file is opened on a specific computer to do an import records to either import new data, update existing data or both.
EIther way, I suggest first reading up on the basic concepts and then reporting back here for any additional details that you need to apply one of these methods to your database project.
Thank you, I will research this and ask any additional questions should I have them.