Having succeeded in creating a form which automatically fills in point-in-time data from another form, I embedded it as a subform. Now I have a problem with linking the subform to the main form as I've had to create a many-to-one relationship from the main form (the many side) to the one side (subform) to enable the autofill already described. To link a subform to a main form requires a many-to-one relationship in the opposite direction.
Any ideas on how this can be achieved would be really appreciated.
Any ideas on how this can be achieved would be really appreciated.
