I am creating a booking app.
I have a database called “ibraries” which contains fields such as:
· Name of the library
· Address of the library
· Total seats
· Free seats
· Occuppied seats
· Map (image)
I also have a database called “Seats” containing the following fields:
· Seat table (letter i.e. A)
· Seat number (number i.e. 2)
· Seat Name (combination of letter and number: i.e. 2A)
· Library (name of the library that the seats belong to)
I created a page that allows you to select the library you want. It shows the map, number of seats, etc. Once the user clicks on the “Reserve a seat” button, I want to navigate to a page that shows a list with all the seats of the library so the user can select the seat they want.
However, I dont know how to send this information or how to link these two databases.
Can anyone help?