First time posting, I'm an Access beginner in need of your guys' help with an Access 2000 problem I'm having.
I'm trying to create a Form that contains a table subform that, for each record in the main form, allows me to fill a new record in the table subform.
I have one table called Client, that has Client ID (primary key), Account Nº, Name, Last Name, Social Security. I also have another table called Products, with Products ID (primary key), Name, Nº Products bought in 2008, Nº Products bought in 2009, Nº Products bought in 2010.
I've attached a jpeg that shows what I've got, the Client Form, that has the Products table subform visible.
But right now, when I go through the main form records, the Table subform doesn't move to a new record so that I can fill it, it's always the same one.