My data are disposed across several linked tables. It is possible to display these in a single form (with controls dependent on subforms) as shown. This contains a main form and six sub-forms. When consulting existing entries, it is possible to edit any of the fields in any of the controls. However, when I want to add a new record, it seems that I can enter data into the controls belonging to the main form (the 'Stamp" area), but they neither prompt display of linked data in the other fields (e.g. if I enter the number of an existing potter), nor enable me to enter new records (e.g. if I enter a new potter no.). I used to be able to do this in Paradox almost without thinking.
Is there something I am missing, or is Base not capable of supporting this level of complexity? (I should add that the properties of each subform are set to allow additions/modifications/deletions.)
Further elaboration on 19 May: this is quite a complicated scenario to explain on this website, so I attach a dummy version of the database, with just a few records, OCK_sample.odb and a text file which gives a fuller explanation of the problem.
OCK sample exp.docx. If this seems inappropriate for this forum, it can surely be deleted.