We develop our volunteer database using the seperation model and having an intermittent issue with a relationship link between the databases. When we login with full access, here is the correct relationship link with volunteer_data_InOut table shows.
The issue happens when we login with guest account. When login as guest, the volunteer_data_InOut table NEVER able to establish the connect with the volunteer_data table (Both tables are from the data database). After login as guest but not fully closed out Filemaker (close the database but not quit Filemaker), full access login also has issue establish the connection.
The volunteer_data_InOut table is important for volunteer to log their hours. Any advice on this intermittent behavior is greatly appreciated.