Ask Your Question

Armestine's profile - activity

2020-07-28 21:27:54 +0100 received badge  Famous Question (source)
2020-07-21 21:10:50 +0100 received badge  Taxonomist
2020-02-27 21:00:26 +0100 received badge  Famous Question (source)
2017-08-23 19:48:46 +0100 received badge  Notable Question (source)
2017-06-10 21:55:32 +0100 received badge  Popular Question (source)
2017-05-23 10:05:42 +0100 received badge  Famous Question (source)
2017-03-15 18:34:00 +0100 received badge  Notable Question (source)
2017-03-07 11:07:59 +0100 received badge  Enthusiast
2017-03-06 08:38:19 +0100 commented answer Filling a form box with one table data, saving into another table's data.

Right, but if I don't know where these options are located how can I study the forms?

2017-03-06 06:40:20 +0100 commented answer Filling a form box with one table data, saving into another table's data.

You say it is a tutorial but I can only find links to the finished invoices on that forum post? Is there an actual step-by-step tutorial there?

2017-03-06 06:35:08 +0100 commented answer Filling a form box with one table data, saving into another table's data.

This seems very useful! I will give it a look.

2017-03-06 06:32:02 +0100 received badge  Popular Question (source)
2017-03-05 16:38:08 +0100 received badge  Notable Question (source)
2017-03-05 10:44:44 +0100 commented question Filling a form box with one table data, saving into another table's data.

Also, I am aware this is bad Database practice, however I have done this with Paradox Windows for 20 years and it has worked perfectly. (but need to move to a software compatible with modern windows hence Libre). So I would like to stick to how I have done it, like this.

2017-03-05 10:39:51 +0100 asked a question Filling a form box with one table data, saving into another table's data.

Hey! so I am writing an Invoice form but I need one thing different from normal: I don't want past invoices to change when I change item prices. But I do want customer info to change when I change that.

How I am doing this is I have 4 tables. Customer, Stock, Invoice and InvoiceLine.

  • Customer is customer info
  • Stock is all stock info
  • Invoice is for storing Invoice Number, Date, Customer and Total.
  • InvoiceLine is for storing the product codes connected to the Invoice number and their price and other information at the time, quantity, price and line total.

So I want an Invoice form and InvoiceLine sub-form. But when I type an item code in the Code section of the InvoiceLine field I want it to Auto-populate the price and info fields in the InvoiceLine subform

Similarly in the main form I want to be able to type a customer code into the customer code field, and Auto-populate a few other boxes with the customer info, but this will not be saved into the invoice table.

Lastly I want the InvoiceLine Total to equal Product x Quantity and Invoice Total field to automatically add all the InvoiceLine Total fields.

So how do I go about this? Mainly what I can't seem to find how to do is populate a field with something and save it as something else.

Thanks for the help.

2017-03-05 10:38:58 +0100 asked a question Filling a form box with one table data, saving into another table's data.

Hey! so I am writing an Invoice form but I need one thing different from normal: I don't want past invoices to change when I change item prices. But I do want customer info to change when I change that.

How I am doing this is I have 4 tables. Customer, Stock, Invoice and InvoiceLine.

  • Customer is customer info
  • Stock is all stock info
  • Invoice is for storing Invoice Number, Date, Customer and Total.
  • InvoiceLine is for storing the product codes connected to the Invoice number and their price and other information at the time, quantity, price and line total.

So I want an Invoice form and InvoiceLine sub-form. But when I type an item code in the Code section of the InvoiceLine field I want it to Auto-populate the price and info fields in the InvoiceLine subform

Similarly in the main form I want to be able to type a customer code into the customer code field, and Auto-populate a few other boxes with the customer info, but this will not be saved into the invoice table.

Lastly I want the InvoiceLine Total to equal Product x Quantity and Invoice Total field to automatically add all the InvoiceLine Total fields.

So how do I go about this? Mainly what I can't seem to find how to do is populate a field with something and save it as something else.

Thanks for the help.

2017-03-05 10:10:02 +0100 commented question "background color" and "border color options missing in Base form

http://imgur.com/qPask3y That doesn't work^?

2017-03-05 10:09:14 +0100 received badge  Supporter (source)
2017-03-03 00:08:04 +0100 received badge  Popular Question (source)
2017-03-02 22:45:30 +0100 received badge  Student (source)
2017-03-02 11:24:31 +0100 asked a question "background color" and "border color options missing in Base form

Hey, I just recently started using base and already ran into a really strange problem. When going into control and then general for anything in my form all the color options are completely missing. They just are not there. image description

That is the image. The same thing happens no matter what I have selected and changing color in the toolbar changes only a little strip at the top of the form as if I have it selected.