Setting up a relation column and a lookup column

I have updated app which you may peruse at
I used two tables the at the
In data editor I have added a booking office email column in the HHM table and the 2nd table bookings contain 2 columns ‘controlling office’ and ‘booking office email’ which includes all entries in HHm_2 table but excludes multiple entries in the column.
I used the choice component and wrote to choice column in the ‘bookings’.

where in I created a relation column 'Bookings" between controlling office in HHm_2 and booking office email . further I created a look up column for relation bookings. my lookup column is not being used anywhere?
Although the app serves the purpose to some extent but I fail to comprehend ;
1.whether the Pension Paying office which are chosen by choice component are due to the relation column bookings in the table are due to the controlling office column in the table. i.e. if I remove the relation column will I get the same result.
2.Why my lookup column not working and how to remove the controlling offices column by setting a relation and a lookup column and . in short how to set the lookup column in the tables ?.
3. In which table relation column and lookup column are required to be set in the instant case and and as a general rule.
I’m stuck up.
Pl guide
v wad

I’m sorry, but I don’t understand what you are asking here.

It’s not working, because your relation column is empty. Can you show how your relation is configured please?

Relations and lookups can be added to any tables, and should be added where ever they are needed.

Im sorry I could not make things clear to you.
In fact, I have two tables’ 1. bookings and2. HHm_2.
bookings contain 3columns
1.Controlling office and office email.
and choices column to write the choice component.
HHm_2 contains among others main columns as under:
booking office Email
controlling office and booking office email columns are same in both the tables with a difference that in HHm_2 table there are some repetitions of the Columns data some ‘Places’ have more one controlling offices and so emails.
Further I created a bookings tab in the app where I fetched data from bookings using choice component: source-bookings; values -booking office email; display as ‘controlling office’ so that all the controlling offices shown- when any one is clicked the relevant ‘booking office email’ is written in choice column in bookings and appropriate email is displayed in the app through action text as per image below;

Else where in the community I was advised that if Controlling office is not absolutely necessary, I can set it to write the rowID to the cell containing the choice and relate that to the table and retrieve the email using a look up column.
I created a relation column in bookings table “Bookingoffices” and configured it to the controlling office column in HHm_2. which no doubt seems empty. I also created a lookup column in the same table that looks up the relations column. I was trying that and I failed.
As per your comments it is not working because relation is empty. what should I do to populate it so that lookup column works?

Relations work when both values match exactly. I’m not sure so follow, but are you trying to link an BookingEmail to a Controlling office? If so, those are not matching values. A matches A, but A does not match B.

1 Like

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.