ggiorgianni
New member
- Local time
- Yesterday, 23:52
- Joined
- Jan 20, 2019
- Messages
- 3
Hello everyone, I am here for the first time. I am trying to relate two tables in access from the menu Tools>Relationships:
The first Table is:
Table_GANTT
ID BeginningDate EndingDate Event
1 18/01/2019 21/01/2019 A
2 21/01/2019 31/01/2019 B
3 31/01/2019 30/03/2019 C
The Second Table is
Table_EVENTS
ID Date
1 19/01/2019
2 20/01/2019
3 21/01/2019
4 22/01/2019
5 22/02/2019
6 23/02/2019
I'd like to relate Table_EVENTS to Table_GANTT
so that each Date in Table_EVENTS is related to an Event in Table_GANTT.
Basically, I'd like to associate to each date in Table_EVENTS an Event which happen in a range of date.
In Filemaker
from the menu "Manage Database>Relationships"
it is sufficient to link
Table_EVENTS.Date to both Table_GANTT.BeginningDate and Table_GANTT.EndingDate and state
Table_EVENTS.Date>=Table_GANTT.BeginningDate
And
Table_EVENTS.Date<Table_GANTT.EndingDate
Then All the data in the tables are referenced
How is it possible to do this in Access?? I'd like to make a true relation not a query.
Thanks a lot for your time and help
The first Table is:
Table_GANTT
ID BeginningDate EndingDate Event
1 18/01/2019 21/01/2019 A
2 21/01/2019 31/01/2019 B
3 31/01/2019 30/03/2019 C
The Second Table is
Table_EVENTS
ID Date
1 19/01/2019
2 20/01/2019
3 21/01/2019
4 22/01/2019
5 22/02/2019
6 23/02/2019
I'd like to relate Table_EVENTS to Table_GANTT
so that each Date in Table_EVENTS is related to an Event in Table_GANTT.
Basically, I'd like to associate to each date in Table_EVENTS an Event which happen in a range of date.
In Filemaker
from the menu "Manage Database>Relationships"
it is sufficient to link
Table_EVENTS.Date to both Table_GANTT.BeginningDate and Table_GANTT.EndingDate and state
Table_EVENTS.Date>=Table_GANTT.BeginningDate
And
Table_EVENTS.Date<Table_GANTT.EndingDate
Then All the data in the tables are referenced
How is it possible to do this in Access?? I'd like to make a true relation not a query.
Thanks a lot for your time and help