Hi
I hope this is easy to understand.
I have a From Called FrmJobs and It updates a table called tblJobs
I have another table called tblSeals
What I want to do is in my FrmJobs I want to look up a Seal from tblSeals using a combo box, select the unique seal number value stored in field BoltNum and the toggle box called BoltUsed turn to True so that my Table Jobs now links a specific JobID to a Specific BoltNum in tblSeals.
I just don't know enough to do this. I have however got a query running that lists all bolts where the BoltUsed value = False so everytime I add a new job and select a new bolt, that bolt (each has a very unique ID in the world) it never able to be selected again.
Any ideas?