I have three tables which are related through date (i.e date is the only common field in all three tables). There will be only one user of the database (me). I would like to make a form from where I can input data to the tables. I have tried to make the form the following way.
I have put date on the form (the "date" - field comes from one of the tables). Thereafter I have included all the fields I want to have from the first table (the date field is also from this first table). So far the form works, but when I then add a new field from another table and push "form view" the form is portrayed blank without any information on it (only the background). Please suggest me how to solve my problem so that all the fields I want from the three tables can be portrayed and data inputted on the same form according to the same date.