Sounds to me like you should have TWO tables: one for the part number, the other for the serial numbers with a one-to-many relationship between the tables - one part can have many serial numbers - you would need two fields in the serial number table: ID (PKI), and the serial #, and two fields in the part number field (Part # and ID - ID IS PKI). I would use Auto# for both of the "ID" fields. You can join the two tables on a form where you can have the part number in the top half, and all of the different serial #s in the bottom half if you do it this way. Hope this helps!
Alienwebmaster ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessVBACentral/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
