Hi,
I have two tables. 1 - a table contains quote number, approval date, country etc.. 2 - a table to key in the quote record whenever I create one.
I want to - whenever I enter the quote number into table 2, it retrieves country, approval date, requester etc from table 1. I've tried to build relationship between these tables(table 1 as parent) and added lookup fields. But the field names populated without field values.
Could you please advise where I did wrong? How should I do it?
Thank you!
------------------------------
Annie
------------------------------
Question
How do i populate few fields from another table?
This topic has been closed for replies.
+17Hi Annie,
A relationship is the right way to pass information from a Parent Record (Your Quote table) down to your Child Table (Quote Records?) You would want a relationship where 1 Quote could have many Quote Records. Then you would need to go into each Quote Record and update them to connect to the right parent Quote in the Related Quote field (or whichever field you chose as your reference proxy). This way the records will line up and the lookup fields you add to the relationship will then pass down once they have been related together.
One thing you want to make sure is that the fields you have on the form are indeed the lookup fields you create inside that relationship as part of it and not another field with a similar name. You would also want to make sure the Related Quote field you are filling in is the one that is part of your current relationship. Sometimes when a user creates a relationship and then deletes it and creates it again they end up with multiple fields with very similar names and that trips them up. If you are still having trouble that that point you can also connect directly with our Care team and they can schedule a screenshare with you to take a look at your app together one on one and walk through what might be tripping you up. I hope this information is helpful Annie.
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------
A relationship is the right way to pass information from a Parent Record (Your Quote table) down to your Child Table (Quote Records?) You would want a relationship where 1 Quote could have many Quote Records. Then you would need to go into each Quote Record and update them to connect to the right parent Quote in the Related Quote field (or whichever field you chose as your reference proxy). This way the records will line up and the lookup fields you add to the relationship will then pass down once they have been related together.
One thing you want to make sure is that the fields you have on the form are indeed the lookup fields you create inside that relationship as part of it and not another field with a similar name. You would also want to make sure the Related Quote field you are filling in is the one that is part of your current relationship. Sometimes when a user creates a relationship and then deletes it and creates it again they end up with multiple fields with very similar names and that trips them up. If you are still having trouble that that point you can also connect directly with our Care team and they can schedule a screenshare with you to take a look at your app together one on one and walk through what might be tripping you up. I hope this information is helpful Annie.
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.