Creating Multiple Records Based on List in a Field

[dgutsche]

Hello all!



I am constructing a database that is composed of two tables, one for tickets and one for cylinders. Each ticket can have up to several cylinders associated in it. When a ticket is submitted using a form I have created I want one of the fields to generate the right amount of records in another table (Cylinders) at the same time that the single record is created in the primary table (Tickets).

In this field the user would enter a list of numbers. For each number in the list a new record in cylinders is created.

Ex: User enters "4,7,7,14,28"
In Cylinders a set of records are created with each of the numbers populating a field called "Break Age"

I appreciate if someone can give me a push in the right direction even if it's not a full solution. I've been using Excel forums for a couple years with great success (mostly VBA solutions) but I'm upgrading my skills and building my first database. I am having difficulty finding relevant posts - probably because I do not know how to phrase my question.

Thanks and happy coding / databasing everyone!

[June7]

Hello and welcome, dgutsche. One reason your question interests me is I work in a materials lab and program our database. I just revised some code that dealt with calculating cylinder break date. How serendipitous is that!

It should be just as easy for user to enter each number into a single record as it is to type a comma separated string.

Suggest you use a form/subform arrangement. Main form bound to Tickets table and subform (datasheet or continuous) bound to Cylinders table. No code required and the field with the CSV string is not needed.

[dgutsche]

Hello and welcome, dgutsche. One reason your question interests me is I work in a materials lab and program our database. I just revised some code that dealt with calculating cylinder break date. How serendipitous is that!

Ha ha thanks for the welcome! I just wanted to follow up that I think this will definitely get me in the right direction - at work I primarily work in the field and then sometimes work in the office. When I do get around to it I think your approach will work quite nicely! Thanks!