OK Folks, it’s been a week and I still do not have this working as it should. I have tried TWO ways to get this to work, 1) using a Table and 2) using a Repeater. There are 3 databases at play here:
- Members who own one or more car
- A registry of the Car, each car has a unique dash number, the registry contains all the details about the car, dash number, vin number, owner email address, color, engine, miles, options, previous owners…etc.etc. 39 fields.
- A third database is a Dynamic Photo gallery to grab photos from Cloudinary. Some cars may have only a few photos while others may have 50 or more.
The main page: Review-Search-Registry ( Once I get it working plan on adding search) right now it is ONLY display.
Functionality: The View Registry page should get the 1st car from the Registry database (sorted by dash#), and present the dash# , Vin#, and color, on the Repeater, then based on the email in the registry look up the owners name, city and state from the Membership database and display that on the Repeater. Then based on the dash# in the Registry, lookup and display the and thumbnail image URL from the “Photo Registry” and make it a link to a Dynamic Photo Gallery that will display images listed for that car by Dash-No. The images are stored on cloudinary.com.
If I PREVIEW the page View-Search-Registry, it displays the 3 cars I have stored in the database, BUT Only the First entry is correct. The second and third entry SHOWS the owner information from the first entry. Somewhere along the way, I broke the ability to link to the photo_image-URL in the CV-Photo-Registry. Earlier in the week, this was working, but the dynamic page show all the photos for dash# 001 but kept on going showing all 9 images???
I logged a ticket with Wix support who suggested not using repeaters but using a Table. I followed his instructions and created View-Search-Registry-Test. It is not working at all the page launches and displays “Loading…” FOREVER, like maybe its in a loop? There ARE 1400 entries in the Members Db but I only populated the Registry with 3 cars and populated the Photo-Registry with 3 photos per car…total of 9 photos(URL Links). I called into support and was told this this is Wix Code and they could not help me. Duh! there is not a singlle line of wix code in any of this! Its ‘out of box’ use of reference fields.
Ironically, I built this very site 18 years ago using IBM Informix database and ESQL-C programming language. The site is running in-house on am IBM-Think Server on Oracle Linux. But it is old, dated, and needs to be moved to a modern environment.
Any help is greatly appreciated.