Hi there good people I have been a casual and basic filemaker user for a number of years, starting with the simple form that was included with ClarisWorks all those years ago. I recently decided to challenge myself to write a database to help easily decipher and record manufacturing codes for a hobby I am involved with - Vintage BMX Bikes.

To say the least I have stumped myself well and truly and am looking for some assistance. Here is my dilemma: I know for certain the meaning of the sequence of the numbers and letters in the stamped serial number but I can't get my head around transforming it to a database! EG: Bike frame stamped 9143D I know that this can be broken down to: 9th month (September), 1981, 43rd in sequence, Welded by Darrell Kendall Frame stamped 501161D Is 5th month (May), 1980, 1161st in sequence, welded by Darrell Kendall There is physical evidence on the frame of the model change so that can be marked in the database.

What I really need help to work out is what is the best way to be able to type in the number and character stamped on the frame and have it decoded??? Hopefully someone can point me in the right direction. Many thanks in advance. Are all bikes manufactured in the eighties? How many welders are there? Is the welder always identified by a single letter?

There is why we have numbers of text editors in Linux. The Kia Stinger GT Is Kia's Fantastic 365 HP Rear-Wheel Drive Sport Sedan. The Kia GT4 Stinger concept from 2014 was the concept car you wished was real, and it lives. Reflection Piano Sheet Music Pdf. Cisco IOS Cheat Sheet. These commands are used on all Cisco devices running the Cisco IOS. Default is 1. After getting some reasons of how this cheat sheet for. 06 mitsubishi eclipse gt owners manual. 350 manual new holland serial number guide lamona. When coming with vespa granturismo gt. Template polaris sportsman 400 engine serial number. Pro c controller owners manual flvs pre algebra cheat sheet.

We think all bikes are manufactured in the eighties - you would not believe how hard it was to crack this code - the bikes made in the seventies have totally different serials - which still haven't been deciphered yet 2. From what we can tell there were 3 welders all identified by a single letter - their first initial (there are also prefixes for special edition bikes but they are quite rare and can be dealt with on a case to case basis ie T for team rider bike). What I'm not clear about is what they did in October, November or December, as there appears to be only a single digit for the month. HTH Brian That is what confused us for some time! Following the sequence, purely for illustrations sake, the last December 1981 frame, build sequence 256 welded by Mark Bradshaw bike would be stamped 121256M then a January 1982 welded by Darrell would be 12257D When we only had a few frames as reference you could understand our difficulty in establishing their heritage Cheers Ben. Brian's remark is right on the money: how can you tell that '121256M' is not January 1982, #1256 or that '12257D' is not December 1982, #57? Now you encountered the difficulty of my task It is known that there are two models - the second commencing in September 1981 eg: 918D Unfortunately we feel there might be an overlap from version one to version 2 of maybe a month or so So in summary - the code for the stamping remained the same but was re-set with no additional acknowledgement So we also know that the first edition frames were stamped in the same way but from (we think) September 1981 the build sequence was reset to '1' Luckily visual appearance can tell these two apart. Goudy Trajan Free Font Download.