Unanswered: How do I 'link' subforms to records within a form?
ABout 18 months ago I devloped a simple database that takes some information in an excel file and drops it into a table, which I can then use to run simple queries (grouping etc). It consists of a single table that gets added to every time I import from the spreadsheet.
However, I now want to add more information to the individual records, which are all unique, by manually keying this into a form. I have started by creating a seperate table and relating this back to the original using a 'one-to-many' join. I have also created my form and subform but am stuck because I can't force information keyed into the subform to match with the original record id found in the original table.
I'm sure it must be something simple but can't for the life of me figure out what that is, even after studying the "Orders" form and subform in the Northwind database that I've been using as an exmaple. Any advise would eb gratefully appreciated.