Apache OpenOffice Community Forum

Hello, new member here. I am completely new to databases except the little knowledge I remember from IT at school. I am making a simple database to input customer billing and shipping addresses to populate Invoices, Receipts and envelopes with their details via Mail Merge. I have got the Mail Merge down and working but my issue is, I would like an option button to tick that will copy text from multiple fields to multiple others within the same record for when the billing and shipping addresses remain the same. I.E copy each relevant field of the billing section to the corresponding field in the shipping segment. hope this makes sense. Is this a possible task? Will it need to be done via a Macro? (if so there's another thing I will need to learn). I have included a screenshot of the form which you can see the option button labelled and the 2 columns of info I would like copied from the left column to the right upon selecting the button. Thanks in advance.

I don't think you should do this. One of the rules of database design is to avoid duplicating information. You can handle this in queries by checking if "Shipping same as Billing" is TRUE. A CASE WHEN statement could select whether to use the Billing or the Shipping fields based on the TRUE/FALSE value.

Ok, thanks that kind of went over my head, I will start digging on how to use Queries then, thankfully, I like to learn. The geek in me is loving all the cool features I am learning with office software.

Additionally, consider implementing a view that automatically handles these conditions, so you can simplify both reporting and form management without altering your core data structure