[Solved] Creating a form which fills multiple records

[beejayzed]

Hi
I have a table which has three fields: ID, Date, Number.
Most of the time one date will duplicate for multiple different numbers.
I would like to create a form which lets me enter a date, and then multiple numbers (seperated by commas or different boxes). This date will then carry down for each of the records which have the different numbers.

e.g I enter 24/5/08 and 10,7,23,15,8,10,9,5 in the form, and this creates 8 records, each with the same date.

Is this possible? I saw another post about this topic, but it was suggested that the database design be modified. I don't know how this could be modified though.

[Villeroy]

Yes, it's possible if you are able to write macros (scripts that control the behaviour of your form). The general concept is that valid table entries may depend on entries in related tables. Therefor you've got to enter one record before you are able to add other records that depend on the existance of the first one. In real life this should be no problem. If you order a new article from a new vendor you need to add the vendor to some table, the article to another table before you can add the article with it's vendor to your order form. Having huge lists of articles and vendors, you should first add all vendors and articles, then create the relation(s) before you start the orders-table. Writing macros is difficult, probably much more difficult than opening one or two additional forms from time to time.

[beejayzed]

Thanks for the reply.
Unfortunately it won't be once in a while that extra forms will have to be opened, it will be every entry that is entered.
I think I'll look into doing this with python and sqlite, as I already have experience with that, and very little with writing macros.

Thanks for the help.

[Villeroy]

I think I'll look into doing this with python and sqlite, as I already have experience with that, and very little with writing macros.

Great. I guess you'll implement some type of transaction. Anyway, you can still import data from sqlite into Writer and Calc via jdbc or odbc. And you may use Base forms and reports as an alternative frontend.