Apache OpenOffice Community Forum

Hi, I am trying to figure out the best way to be able to add multiple similar entries in a form.
For example, entering data into the following fields.
Part Number
Description
Customer
Size

So i might have an occasion to add say 10 records one after the other, they would all be different part numbers, different descriptions but the customer and size may be the same.

So for the first entry i add the part number, description and then choose a customer and size from the listbox.
I want to have a checkbox next to customer and size so when checked the form retains the current customer and size (and check box status) for the next record when I press save.

I previously worked this the other way around where i added the Customer, Size and then entered the part numbers into a control table.
This was fine but I could not figure out a way to stop duplicate entries into the control table.
I did hope to replace the control table with another form so I could add a macro to convert entries into uppercase (and use index design for unique field) but failed to progress with that.

Either way the above checkbox would come in useful for other scenarios.

Any help appreciated.

Look here for a different approach
Base Copy Field or Clone Record - Example

download/file.php?id=22304 two more record cloners without macros.

Brilliant, i will go through these. Many thanks for taking time to share your knowledge, its greatly appreciated.

So i have looked at these suggestions and have decided that they are not best suited to my requirements. I think i will revert back to trying to create a form whereby i enter the fields which i want to be used on the next record in one form which then populates a subform which has an additional field or two.
I had something similar working but it used a control table and I could not workout how to stop duplicate entries into the database.
I will mark this as solved as I think the suggestions would work for many people.
Thanks guys.