External Data Source Table
I have a FM db that is using a table from an external data source that populates a members list. The member list in the FM db has a relationship with the external data source using an ID. I populated the FM db and established that relationship by importing all the ID # from the external data source which works great, however if a new member is added in the external data source table I need a way to only add in a new member. Hope that makes sense. Any ideas would be greatly appreciated!