SQL

Create table

                CREATE TABLE tblMaintenanceRecords(
                    pmkMaintenanceRecordsID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
                    fldMileage VARCHAR(10),
                    fldDate VARCHAR(10),
                    fldMaintenancePerformed VARCHAR(150)
                )
            

Insert Data

                INSERT INTO tblMaintenanceRecords
                (fldMileage, fldDate, fldMaintenancePerformed)
                VALUES
                ('~214,250', '4/25/22', 'Replaced wheels and tires (15 x 7 Sparco FF1's, 195/50R-15 Yokohama Advan Fleva V701 SL)'),
                ('~214,250', '4/25/22', 'Replaced windshield wipers'),
                ('~214,250', '4/26/22', 'PA state safety and emissions inspection (passed)'),
                ('~214,250', '4/26/22', 'Replaced soft top (Robbins soft top, glass rear window)'),
                ('~214,300', '4/27/22', 'Full interior detail'),
                ('~214,300', '4/27/22', 'Oil change'),
                ('~214,300', '4/27/22', 'Replaced alternator belt'),
                ('~214,300', '4/27/22', 'Replaced accessory belt (PS/AC)'),
                ('~214,300', '4/27/22', 'Replaced PCV hoses')
            

Select Records

                SELECT fldMileage, fldDate, fldMaintenancePerformed FROM tblMaintenanceRecords
            

Create table for form

                CREATE TABLE tblMiataSuggestionsForm(
                    pmkMiataSuggestionsFormID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
                    fldFirstName VARCHAR(25),
                    fldAge VARCHAR(3),
                    fldEmail VARCHAR(30),
                    fldCarEnthusiast VARCHAR(15),
                    fldMiataSuggestions TEXT
                )
            

Insert Data

            ?, ?)