Display captured ratings from Database (A) on Dynamic page connected to Database (B) through unique profile id in Database A. Please help

Hello,

I have a database (A) with average ratings for individual companies on each row with unique profile ids. Ratings were captured through lightbox on repeater connected to database (A) from logged in members.

Example:-
Company name: Travel Lounge Inc
Profile Id : #ta0006

I have a dynamic page which opens from button “View Itinerary” on repeater connected to database (B). The Dynamic page will show services offered by a company “Travel Lounge Inc”.

I want to display average ratings of “Travel Lounge Inc” company stored in a database (A) on Dynamic page connected to database (B).

Can anyone help me with the code to achieve this?

Hello. Could you do try to do this with a reference field ?

@amandam I am able to get it working with your advice. Thanks :blush: