SOLVED

Creating and navigating a temporary record set.

%3CLINGO-SUB%20id%3D%22lingo-sub-2242489%22%20slang%3D%22en-US%22%3ECreating%20and%20navigating%20a%20temporary%20record%20set.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2242489%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%3C%2FP%3E%3CP%3EI%20have%20a%20table%20(tblMembCars)%20of%20members%20vehicle%20details.%20Primary%20key%20field%20in%20this%20table%20is%20CarID%20(number%2Fno%20duplicates).%20A%20second%20field%20containing%20the%20members%20ID%20number%20in%20a%20field%20called%20MembID%20(number%2Fduplicates%20OK).%20This%20members%20ID%20number%20is%20the%20primary%20key%20in%20a%20number%20of%20other%20tables.%3C%2FP%3E%3CP%3EThe%20form%20(frmMemCars)%20for%20displaying%20this%20data%20has%20next%20and%20previous%20navigation%20buttons%20for%20displaying%20a%20members%20different%20vehicles%20if%20he%20has%20more%20than%201.%20This%20form%20is%20a%20subform%20of%20the%20members%20form%20(frmMembers)%20which%20contains%20the%20members%20ID%20number.%20I%20am%20trying%20to%20limit%20the%20navigation%26nbsp%3B%20controls%20to%20that%20members%20cars%20only.%20I%20was%20thinking%20if%20I%20could%20create%20a%20%3CU%3Etemporary%20record%20set%3C%2FU%3E%20containing%20only%20that%20members%20car%20records%20and%20navigate%20back%20and%20forth%20through%20them%20only.%3C%2FP%3E%3CP%3EI%20know%20what%20I%20want%20to%20achieve%20but%20I%20am%20at%20a%20loss%20as%20to%20how%20to%20go%20about%20this.%3C%2FP%3E%3CP%3EWould%20it%20make%20things%20easier%20if%20I%20was%20to%20swap%20the%20primary%20key%20in%20this%20table%20(tblMembCars)%20from%20CarID%20to%20MembID%3F%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3CP%3ECheers%2C%3C%2FP%3E%3CP%3EGraeme.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2242489%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2242585%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20and%20navigating%20a%20temporary%20record%20set.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2242585%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F992505%22%20target%3D%22_blank%22%3E%40GraemeC_55%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20what%20you%20might%20be%20missing%20(assuming%20I'm%20following%20the%20gist%20of%20the%20problem%20accurately)%20is%20the%20%3CSTRONG%3E%3CEM%3EParent%2FChild%20linking%20fields%20on%20the%20Main%20Form%3C%2FEM%3E%3C%2FSTRONG%3E%20to%20coordinate%20the%20records%20on%20the%20subform.%3C%2FP%3E%3CP%3EI%20have%20%3CA%20href%3D%22http%3A%2F%2Fwww.gpcdata.com%2FIndex%23Music%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ea%20demo%20database%20which%20illustrates%20this%3C%2FA%3E%20on%20my%20Website.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22LinkMasterChild.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F267943i93755BDE21AF58F7%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22LinkMasterChild.jpg%22%20alt%3D%22LinkMasterChild.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 MembID (number/duplicates OK). This members ID number is the primary key in a number of other tables.

The form (frmMemCars) for displaying this data has next and previous navigation buttons for displaying a members different vehicles if he has more than 1. This form is a subform of the members form (frmMembers) which contains the members ID number. I am trying to limit the navigation  controls to that members cars only. I was thinking if I could create a temporary record set containing only that members car records and navigate back and forth through them only.

I know what I want to achieve but I am at a loss as to how to go about this.

Would it make things easier if I was to swap the primary key in this table (tblMembCars) from CarID to MembID?

Thanks in advance.

Cheers,

Graeme.

2 Replies
best response confirmed by GraemeC_55 (New Contributor)
Solution

@GraemeC_55 

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.

LinkMasterChild.jpg

 

 

 

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.