Linking the table together

Like (1) Share

Report

Posted on 7 Apr 2025 18:27:31 by CU23031016-0

Hello,

I have the 3 tables loaded and i have created a new column called Animal location. What this does is grab the current location and if that is empty, goes to initial shelter. I am having difficulties joining these table together. to build forms and views that reference each other. Ok looking back that does not make sense, i work in sql so let me word it that way, I have a primary table and i want to have some joins to another table so when i look at things in views or forms instead of seeing a reference id i get what the actual thing is.

So in this scenario what i need it to do is to take what is in my new column and say hey that is shelter x ok i want to change that to Y and then it updates that. Or am i over complicating what is required here.?

Categories:

General Discussion

All responses (2)

Answers (1)

Verified answer

w.p 3,049 on 07 Apr 2025 at 19:55:07

Like (0)

Report

Linking the table together

@CU23031016-0

It's not required; you can leave it as it is.

But if you want to, it's based on shelter status.

For example,

if the animal is adopted, show the adopter's name.

If it's in the shelter, show the shelter ID or name.
CU31011126-0 5 on 07 Apr 2025 at 18:55:44

Like (0)

Report

Linking the table together

Hi @CU23031016-0,

I think there is a suggestion about the current location which says you may use a formula column to calculate the current location. What you can do is check the value of the shelter status, and depending on its value, populate the current location.

For example, if Shelter Status is In Shelter, use the initial shelter as the current location; if it is In Foster Home, display the foster location as the current location , etc.

If you want to display the actual location, within your formula you may use a lookup to display the Initial Shelter location name or the Foster location name.

Community site session details

Linking the table together

Helpful resources

News and Announcements

Leaderboard

Featured topics

Product updates

Community site session details

Linking the table together

Helpful resources

News and Announcements

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates