Reference problem

Hello,
I created an app to register informations of apartment/buildings that the company is listing. We have to tables, one for the buildings and one for the apartments (because we may be trying to list two or more apartments in the same building and need to save the infos of the doorman besides having them listed or not)
I tried to ref one to another so i could see all the apartments of the building or register a new apt to the building, it did work but it appear the wrong colum,

I’ll try to explain better… I had to put a field to the user put a random number to be used as key (because of the complex type of adresses we have here, they could be the same), so when i ref the code of the building in the building table to the code of the building in the apartment table it worked as I wanted to except that that random number used as key is used as the building code and the user cannot change that. How can i change to the building code be the new building code?

I’m sorry if its hard to understand, I can try another way if its not possible
thanks

Guide on How To Create a Community Post Tips & Tricks ?

Dear valuable members and users, For a long time I’m seeing a lot of multiple and concurrent posts, posts like novels seeming to aim the Pulitzer Price, exactly the same questions by the same user but paraphrased/re-phrased etc. Being a dedicated community member and an AppSheet developer who is reading around 2.5K posts per day, I urged myself to tip on some good advice and best practice BEFORE posting something in the community: #1 - APPSHEET DOCUMENTATION AppSheet has a very good help do…

1 Like