I
Icebox
I have an Access 2007 form that has a primary record in the main form that
draws data from three separate tables. It's an asset database tracking photo
usage; each photo has a unique ID that's the main key. A fourth table, which
records uses of the photo, is on a subform, linked to the unique ID. This is
a 1 to many relationship. There are about 4200 unique photos in the
database, and about 8700 records in the table in the subform. I notice that
after adding the subform to the form, when I attempt to browse through
neighboring IDs, the table treats each subform record as a unique record, so
it can take six or seven tries before one can get to the next photo on the
db.
This is annoying because I often have to check records that I know are near
each other in the main table. Is there any way I can keep the subform in,
displaying the records that belong to each unique ID, but have movement go
from main record to record regardless of how many records are in the
subforum?
Hope this is clear. I'm relatively new to access, and trying to rebuild a
form I had in an old paradox database. Importing the tables went shockingly
smoothly (gave up on 2003 because it couldn't import memo fields correctly),
but I have to rebuilding the forms from scratch.
Thanks!
Mark
draws data from three separate tables. It's an asset database tracking photo
usage; each photo has a unique ID that's the main key. A fourth table, which
records uses of the photo, is on a subform, linked to the unique ID. This is
a 1 to many relationship. There are about 4200 unique photos in the
database, and about 8700 records in the table in the subform. I notice that
after adding the subform to the form, when I attempt to browse through
neighboring IDs, the table treats each subform record as a unique record, so
it can take six or seven tries before one can get to the next photo on the
db.
This is annoying because I often have to check records that I know are near
each other in the main table. Is there any way I can keep the subform in,
displaying the records that belong to each unique ID, but have movement go
from main record to record regardless of how many records are in the
subforum?
Hope this is clear. I'm relatively new to access, and trying to rebuild a
form I had in an old paradox database. Importing the tables went shockingly
smoothly (gave up on 2003 because it couldn't import memo fields correctly),
but I have to rebuilding the forms from scratch.
Thanks!
Mark