Blank Primary Key on Import / Odd Table Join Setup
The way we are doing this isn't ideal. We are taking the CSV reports generated from our software and importing those into Zoho tables. This means that we have three different tables with "OrderID" as a primary key. Obviously in a real database most of this data would be in one table or sectioned off into different ID lookups. Anyway, there are two problems we are running into:
1) We can't easily join these three tables together on the same column in each one because "a lookup on another lookup column is not supported." So I have
Table A lookup on
Table B and
Table C lookup on
Table B, but no way to have
Table A reference
Table C via lookup. I created a Query Table and just joined those two tables using a SQL JOIN. So would it be best to just drop the lookup table idea altogether and just join all three of these tables in Query Table? Would that be more efficient?
2) Now that you know our odd setup.. When I try to bulk upload 30,000 rows of one of these tables all the OrderIDs are blank. I checked the .CSV file and the OrderIDs exist there. So at some point during the upload, Zoho is clearing out my primary keys. Does this have anything to do with our lookup table setup? If we try to do a TRUNCATEADD on a table that already has lookup columns set up will that also cause an issue?