I am a new member... I come from Greece, i havent used MS Access for a long time. Now I am trying to develop a small project and i hope i can find some help from the experts. In my project there is one basic table (Table1) which contains an autonumber primary key field (long integer) and also one more field which contains a description (text). There is also one more table (Table2) which one has its own autonumber primary key and a foreign key taking values from Table1, as also two date values, the start_date and the end-date. The relationship between the two tables are one to many from Table1 to Table2. I would like to be able to enter new records in Table2 by selecting first a relative foreign key and then by entering the two date values from a combo box which will contain the available periods of time so there will be no conflict , with an already existing record entry, regarding the specific foreign key appearing on the current row.
Table1.Code, Table1.Descr
1 F
2 G
Table2.Code, Table2.field1(=Table1.Code), Table2.DateFrom, Table2.DateTo
1 1 01/01/2020 31/12/2020
2 1 01/01/2018 31/12/2018
3 2 01/01/2017 31/12/2017
By inserting a new record in Table2, through Tables datasheet view, after choosing the Table2.field1 from a limit to list control, the cursor is put on the Combo Box for selecting Table2.DateFrom and I do expect to see only the available dates, meaning that the range dates should not be the ones between the already taken for the specific selection in Table2.field1.
Minimum starting date in the application will be 01/01/2015 and maximum the today's current date,
Table1.Code, Table1.Descr
1 F
2 G
Table2.Code, Table2.field1(=Table1.Code), Table2.DateFrom, Table2.DateTo
1 1 01/01/2020 31/12/2020
2 1 01/01/2018 31/12/2018
3 2 01/01/2017 31/12/2017
By inserting a new record in Table2, through Tables datasheet view, after choosing the Table2.field1 from a limit to list control, the cursor is put on the Combo Box for selecting Table2.DateFrom and I do expect to see only the available dates, meaning that the range dates should not be the ones between the already taken for the specific selection in Table2.field1.
Minimum starting date in the application will be 01/01/2015 and maximum the today's current date,