Hi guys
i've especially signed up to the forums in hope to get help.
The last time i have touched microsoft access design was back in 1999 and was just a basic forms and querying the database.
I'm completely out of my depth, and hope come kind soul could help please
The story.
I have a some very old custom software that uses a SQL database, however it is soooooooooo outdated, i cant get it to run on windows 10 (and i dont want to go into the trouble of VMs).
I only use the software as a "lookup" system to find a item in a database, then i copy the text outputs into excel/word for quick templating of documents.
Because i cant use this software on any modern OS, and that i dont use the software for what it is anyway. i have extracted the SQL database into a access file. I was thinking that i could just easily use access for the same result.
The solution that i need
I need to create some sort of form, that queries the database and when i select a item in a list, it adds it to another list, then updates the first list.
The database is like 50,000 entries, and has ID fields and description fields etc.
Basically, i need two lists. 1st list shows the first group of items, when a item is double clicked on the 1st list, it moves to the second list. and the 1st list updates with the relevant nextgroup item that corresponds to it.
So i can try and explain what i mean. ive tried to simulate a example in this picture attached based on fruit!
I hope that tries to explain what i mean. then i can try and expand on it.
Any help much appreciated