# How to copy a boolean to a different table
**URL:** https://community.glideapps.com/t/how-to-copy-a-boolean-to-a-different-table/72434
**Category:** Ask for Help
**Created:** [April 9, 2024, 7:43pm UTC](https://community.glideapps.com/t/how-to-copy-a-boolean-to-a-different-table/72434 "2024-04-09T19:43:50Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)
#### Post date: [April 9, 2024, 7:43pm UTC](https://community.glideapps.com/t/how-to-copy-a-boolean-to-a-different-table/72434/1 "2024-04-09T19:43:50Z")
I have a table for promotional offers.
However I only want these promo deals to be visible on the app if the business is active.
I have a boolean for indicating whether or not the business is active BUT it’s located on a different table.
How do I bring that boolean over to this table?
---
### Author:  [@nathanaelb](https://community.glideapps.com/u/nathanaelb)
#### Post date: [April 9, 2024, 10:36pm UTC](https://community.glideapps.com/t/how-to-copy-a-boolean-to-a-different-table/72434/2 "2024-04-09T22:36:38Z")
In your Deals table, for each promotional offer (on each row), is it clear which company the promotional offer is for?
If not, you would need a column with the company name or company ID (which would be the Row ID from the companies table). This would allow you to link a deal to its corresponding company.
(The reason it’s preferable to use a company ID rather than a company name is because row ID are unique and won’t change, whereas a company name can be subject to name changes, spelling errors, etc.)
Once the link is clear, you can create a single relation in the deals table pointing to the company table. Then use a lookup column point to the relation to pull in another information you need about the company. In your case whether the business is active or not.
---
### Author:  [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)
#### Post date: [April 9, 2024, 10:48pm UTC](https://community.glideapps.com/t/how-to-copy-a-boolean-to-a-different-table/72434/3 "2024-04-09T22:48:35Z")
hi! thanks nathan! I thought that was the right thing to do, but my lookup column isn’t working. perhaps i set it up wrong.
I have my business (salon) relation set up with the row ID, and then I have a look up column through “salon relation” pointing at the boolean and none of them are checked off?
---
### Author:  [@nathanaelb](https://community.glideapps.com/u/nathanaelb)
#### Post date: [April 9, 2024, 10:51pm UTC](https://community.glideapps.com/t/how-to-copy-a-boolean-to-a-different-table/72434/4 "2024-04-09T22:51:48Z")
Could you show a screenshot of how you setup the relation between the Deals table and Businesses table?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [April 10, 2024, 12:56am UTC](https://community.glideapps.com/t/how-to-copy-a-boolean-to-a-different-table/72434/5 "2024-04-10T00:56:44Z")
You seem to have that logic stored in an If-Then-Else column.
Corrected it.
---
### Author:  [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)
#### Post date: [April 10, 2024, 1:38am UTC](https://community.glideapps.com/t/how-to-copy-a-boolean-to-a-different-table/72434/6 "2024-04-10T01:38:23Z")
Thanks guys! @nathanaelb @ThinhDinh