I have two really big tables. One is for the Bids we do, the other is for the actual Jobs we do. Both tables have a ton of data - although nothing similar.
The names of the bid/job are not identical, so I can't join them together with that. I have an Auto ID as AutoBidID going for my Bid table and a different Auto ID as CAS_JOB_ID for my Jobs table. They are obviously different. I need to join these tables so that I can make an app where I can see what bids were accepted (if we have the job - we won the bid) and what ones were not.
Do I need to start a new AutoNumberID and go back to match every name in both tables manually? I cannot think of another way.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
kpcollier
Hey all. Fairly new to Caspio.
I have two really big tables. One is for the Bids we do, the other is for the actual Jobs we do. Both tables have a ton of data - although nothing similar.
The names of the bid/job are not identical, so I can't join them together with that. I have an Auto ID as AutoBidID going for my Bid table and a different Auto ID as CAS_JOB_ID for my Jobs table. They are obviously different. I need to join these tables so that I can make an app where I can see what bids were accepted (if we have the job - we won the bid) and what ones were not.
Do I need to start a new AutoNumberID and go back to match every name in both tables manually? I cannot think of another way.
Thanks for the help.
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.