I have a huge table with many fields or columns and with more than 50,000 rows of data. But I have to insert data in one column-location with respect to another column-access randomly. By using action query I can update only one record at a time. Another solution I think is to use forms, i.e. by creating two text boxes, where access text box is for entering the random number and location text box for entering the actual required data. But for this solution I don’t the coding, or atleast if i can get the tutorial material for how to use forms I can overcomke this problem.
Thanking you.
