Hi there,
I have a two tables called Rooms & Guests
These are linked as one (Rooms) to many (Guests).
ROOMS TABLE GUESTS TABLE
Guests_ID
Rooms_ID >>> Room_ID_Link
Guest_Archived
I would like, as a safeguard some code to prevent the user from adding a new Guest record if there is currently a record associated with the room which is not archived.
I would greatly appreciate some help in forming code for this (my coding skills are very basic).
Many thanks Mark
I have a two tables called Rooms & Guests
These are linked as one (Rooms) to many (Guests).
ROOMS TABLE GUESTS TABLE
Guests_ID
Rooms_ID >>> Room_ID_Link
Guest_Archived
I would like, as a safeguard some code to prevent the user from adding a new Guest record if there is currently a record associated with the room which is not archived.
I would greatly appreciate some help in forming code for this (my coding skills are very basic).
Many thanks Mark