When adding a relation field in a collection, it’s not clear how I can point it out to a specific field. For instance, I have a collection called “Booking” that should also contain the userID or username of the user who made the booking. Instead of adding a regular field, I added a “relation field”.
- is it accurate to say that any relation field added, will add a new relation field in the other collection?
- is it better to use relation field or instead use a text field that stores the value?
- how would using relations help (or make it more complicated) when deleting a record from one of the collections?