A message box is required if all tasks completed

[boblarson]

After looking again, I see that you do have a primary key in the Orders table, but not in the OrdersID table.

So it should be added:

 

[aymanmb]

Thank yu for your time and care, a reall master.

as for the keys, I will do a primary key for the OrderDetails table.

I understand that foreign key means that I will link this field e.g. OrderID field of Orderdetails to its field in Orders table.

Annd that on the orderDetails table only one key will appear (visually) which is the primary key but the foreign key will not represented by the key sympol, Am I right.

thanks

 

[boblarson]

Annd that on the orderDetails table only one key will appear (visually) which is the primary key but the foreign key will not represented by the key sympol, Am I right.

You are Correct

 

[aymanmb]

Final request Bob,

I want to modify code above so that if the user uncheck one of the orderdetails records to check if not all records are checked to ask the user to remove the EndDate if it was entered before.

thanks

 

[aymanmb]

Dear Bob,

I managed to do it myself (last request above), I am gratefull to you and happy that I managed to manipulate the code and achieve what I want

thanks again

 

[boblarson]

Glad to hear.