Forum Discussion
Solved
Creating and navigating a temporary record set.
Hello all, I have a table (tblMembCars) of members vehicle details. Primary key field in this table is CarID (number/no duplicates). A second field containing the members ID number in a field called...
I think what you might be missing (assuming I'm following the gist of the problem accurately) is the Parent/Child linking fields on the Main Form to coordinate the records on the subform.
I have a demo database which illustrates this on my Website.
I think what you might be missing (assuming I'm following the gist of the problem accurately) is the Parent/Child linking fields on the Main Form to coordinate the records on the subform.
I have a demo database which illustrates this on my Website.
Hi George,
Thanks for that.
Creating relationships was something I had forgotten about. from 18 years ago. There is so much I have to re-learn.
Now all I have to do is limit the navigation to the number of cars that member has. I have done a query that shows the duplicates but I have to work out to use that data.
Luckily, I am in no hurry to get this done. A target of 12 months has been set to get it right.
Cheers,
Graeme.
Thanks for that.
Creating relationships was something I had forgotten about. from 18 years ago. There is so much I have to re-learn.
Now all I have to do is limit the navigation to the number of cars that member has. I have done a query that shows the duplicates but I have to work out to use that data.
Luckily, I am in no hurry to get this done. A target of 12 months has been set to get it right.
Cheers,
Graeme.