# Expand access of Record IDs in builder

**URL:** https://forums.knack.com/t/expand-access-of-record-ids-in-builder/9424
**Category:** Feature Requests
**Tags:** custom-code
**Created:** [June 5, 2017, 12:41pm UTC](https://forums.knack.com/t/expand-access-of-record-ids-in-builder/9424 "2017-06-05T12:41:00Z")
**Posts on this page:** 1
**Page:** 2

<div class="post-metadata">

### Author: ![CSWinnall](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/cswinnall/32/3631_2.png) [@CSWinnall](https://forums.knack.com/u/CSWinnall)
#### Post date: [October 13, 2023, 2:23pm UTC](https://forums.knack.com/t/expand-access-of-record-ids-in-builder/9424/21 "2023-10-13T14:23:25Z")

</div>

Hi All

I got around this by adding a field Object\_PK\_Gen and then setting a short text Object\_PK field to Unique and Required.

The text formula uses the auto increment field and looks like this:  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/e/e02b4c305f34ae3fb7e87c5ef0ef136f49d984ae.png)

The short text has a conditional rule on it like this:  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/9/958f53ccce1ede7715344a712fd0a17a6a4e6610.png)

You can then do the same in other objects connected to the previous object using Object\_FK\_Gen & Object\_FK like this:  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/4/4d8fff12a3a571c4dc82c711ec57812a89787804.png)  
&  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/8/8dc5eaa974895712acfbbdc200934ff596d3b3ec.png)

I know this isn’t exactly what you are asking for but it is a work around that doesn’t use code and it will run on all previously added records.

You can then use Primary Key to search all connected objects with the same Foreign Key.

Craig

[Previous page](https://forums.knack.com/t/expand-access-of-record-ids-in-builder/9424.md?page=1)