Create a series of Records

[Marcel Allenspach]

Hi

I've got 2 tables, one (dates) with a simple date field (date) and a index (date_index), the other one (halfdays) with the following fields: halfday_index, halfday_code, date_index.

Now I've populated the dates table with severals dates. I would now like to create two records for each date in the halfdays table, the first record should have halfday_code = "morning" and the other one "afternoon".

Thanks
Marcel