I have a a multiple table database. (Requests, Reports, Projects, Employees, etc..)
I am using Column Type: Lookup to pull data from the Employees table to the Requests table using a form.
There are a number of things going on.
First, if I go to the column and edit it after it has been created to check it, the 'Existing Reference*' is blanked out but the 'Lookup On' is still selected.
Second, I have an error in the App Schema with the table as 'out of sync' I have checked all the columns and everything matches. I regenerate and it does not fix the issue.
Third, Appsheet is changing my Column Types which are lookups in the database to 'Show' in the App instead of 'Text' or "Ref'
I have been breaking this and rebuilding it for a week, trying to figure out some combination of anything that will work.
Help!
Thank you.
LinkedIn
Twitter
