PeterTeuben
New member
I'm creating a database for events and have a Table containing Dates and the Event_ID (one to many relation).
Because an event can have many dates.
I want the customer to choose the date and the Event name with the Fieldtype: select_single
But I can't get the date and Event name together in the select_singel.
The single_select shows the Date and the Event_ID:
15-02-2017 - 3
But what I want them to see is the Date and the name of the Event with select_single:
15-02-2017 - Concert Mozart
Is this possible?
Here is the information from the tables I use and the Dadabik information:
Tabel: Event_Dates
ID (int)
Date (date)
Event_ID (int) (foreign key to tabel Event ID)
Tabel: Event
ID (int)
Name (varchar)
Dadabik information Event Dates:
Fieldtype: select_single
Primary key: ID
Primary key table: Event_Dates
Linked fields: Date~Event_ID
Example:
Event_Dates
ID: 1 Date: 15-02-2017 Event_ID: 3
ID: 2 Date: 05-05-2017 Event_ID: 3
ID: 3 Date: 16-08-2017 Event_ID: 3
Event
ID: 3 Name: Concert Mozart
Because an event can have many dates.
I want the customer to choose the date and the Event name with the Fieldtype: select_single
But I can't get the date and Event name together in the select_singel.
The single_select shows the Date and the Event_ID:
15-02-2017 - 3
But what I want them to see is the Date and the name of the Event with select_single:
15-02-2017 - Concert Mozart
Is this possible?
Here is the information from the tables I use and the Dadabik information:
Tabel: Event_Dates
ID (int)
Date (date)
Event_ID (int) (foreign key to tabel Event ID)
Tabel: Event
ID (int)
Name (varchar)
Dadabik information Event Dates:
Fieldtype: select_single
Primary key: ID
Primary key table: Event_Dates
Linked fields: Date~Event_ID
Example:
Event_Dates
ID: 1 Date: 15-02-2017 Event_ID: 3
ID: 2 Date: 05-05-2017 Event_ID: 3
ID: 3 Date: 16-08-2017 Event_ID: 3
Event
ID: 3 Name: Concert Mozart