I have used FM for many years but this is my first try at creating a relational db. I have looked at many of the responses on setting up a relationship and still cannot get it correct. I can create tables,and join them with primary and foreign keys but cannot wrap my head around how the foreign key gets populated with the information from the primary key.
I am trying to set up a relational database for an RV park I work for. I want to be able to set up a reservation system so I can see which spaces are open on specific dates so I can make the reservation for customers and view all of the reservations for all of the spaces.
One customer can make many reservations, spaces can only have one reservation per day, and days can have multiple spaces reserved.
Can anyone please help me what tables/fields I would need,to get the relationships set or point me to the best resource for learning how to set up the database.
Thank you for any help/resources you can provide.