I have a very frustrating problem, yet I am sure it is quite a simple one to answer.
I am building a database with two tables.
The first table holds information such as name, date, change number etc and the second table holds the actual change to the data itself, ie Qty, part number etc. There is a common field in both table (called change number) so that the many changes in the second table can be linked to a single in the first table ie it has a one-to-many relationship.
To represent the data I have a form and on that form I have a sub-form. The parent form has textboxes (which will be linked to the data in the first table) etc but in the sub-form I need a way of displaying a grid to enable me to enter data into the second table. At the moment the sub-form is a form made to look like a datasheet but the grid will not show until it is bound. The whole idea is that data is not entered into either of the tables unless it is saved, otherwise is should be discarded.
Does anyone have any advise please?