but the subform is blank and I cannot edit it what so ever
For the form (sub form) "frmObjednavkyDetail", you cannot edit because of these properties:
Allow Additions = No
Allow Deletions = No
Allow Edits= No
Another problem is that the form "frmObjednavkyDetail" should have a record source that is a query:
Code:
SELECT tblObjednavkyDetail.PKDetailObjednavkyID, tblObjednavkyDetail.FKObjednavkaID, tblObjednavkyDetail.FKProduktID, tblObjednavkyDetail.SerialNumber, tblObjednavkyDetail.Cena, tblObjednavkyDetail.Poznamky
FROM tblObjednavkyDetail;
Note that it is one table.
In the subform, the control for product ("FKProduktID") should be a combo box. (at least that is how I would have it).
Also, the dB acts like there is corruption occurring/happening. Strange things are happening.....