Existing Reference in Column Type: Lookup being removed by Appsheet

[CANA-IT]

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.

[Steve]

I recommend against using AppSheet Database. Consider using Google Sheets instead.

[CANA-IT]

I would have to basically start over to use Google Sheets vs AppSheet Database. I'm not saying I won't and I have thought about it. So I appreciate your input. I will try WhoTripathi's suggestion first before starting over from fresh.
I have almost everything else working.
One thing I didn't mention was, It will not allow my bot to perform it's copy function.
When something is "approved" the bot grabs all the data and copies it to a different table for the rest of the process. For whatever reason (could be a database thing) it will not copy over.
All values are mapped to their corresponding columns between the tables.

[CANA-IT]

So... another question concerning a similar issue.
I have a bot which copies a row from one table to another when an approval happens.
But any data which is a "Ref" on the Source Table shows up as what looks like "Row ID" (fLwA5aiSV44nIuBJTX8Ox4) on the Destination Table.

Any ideas?

[Steve]

It's either the way you're copying the row, or the label column of the destination table is set incorrectly.

[WhoTripathi]

Instead of passing the lookup under the ASDB(keep the lookup column text only in ASDB), I will suggest you to use dereferencing in the Appsheet application table.

Expression of the column (which you were using lookup earlier in ASDB) would be following: [ref-column].[value-column].

https://support.google.com/appsheet/answer/10107396?hl=en#:~:text=and%20Address%20columns.-,Derefere...

[CANA-IT]

Thank you.. I will try this and let you know how it goes.