Can I link a database of resume`s to a text box located in a dialogue box

[AudioBill]

I am designing a website for a staged play that, over several years have had many different people involved as actors and/or production crew. Currently there are over 60 people that have been a part of this play. I have a page with all cast and production members. As the user clicked on a picture of a member, the resume of the member pops up as a dialog box.

I also have a single page for each presentation of the play in a different city and date. Currently there are about 12 cities/dates and therefore 12 pages. On each page is a list of the cast and crew with their picture. Again the user can click on the picture to see their resume`.

To make the dialog box/resume`s available for all pages, I put all 60 dialog boxes on the master page. As you can imagine, it's a mess.

Is there a way to put the actor/crew unique member name and his/her resume in a database and then have one dialog box call up the contents from that database?

I hope I explained this OK and also hope that its possible along with an example somewhere.

Thanks

Bill

[BaconFries]

Yes it is entirely possible but it will require a custom solution using the likes of php and a database (MySql) at the backend and the likes of javascript to open the results in the dialogue in the website/page. There is no example as this is specific to your needs sorry.

[AudioBill]

Oh my... in other words... way way over my head

[BaconFries]

Not entirely have you looked at using one of the AI platforms? Try using the following in the likes of Gemini ir Copilot and see what it comes up with.
"Is there a way to put actor/crew unique member name and his/her resume in a database and then have one dialog box call up the contents from that database?"

[AudioBill]

Oh, OK thanks

[Pablo]

Note that you do not need a complicated database. it can just be simple text file.
You can then create a script to load the file and search for the name.
I have done this myself a few months ago for a project, so it is doable.