Page 1 of 1

[Solved] Advice on creating my first database

PostPosted: Sat Jul 07, 2018 12:31 pm
by neiloneil
I want to create a working database , which I can use, edit, and learn from. Getting started is proving too difficult for me though. I have, over the years tried and given up multiple times. I have followed advice from youtube videos and form other sources, which seem to make sense , but it doesn't ever come together as I expect.
would somebody help me please? I need a form with the relevant tables to achieve the following columns as attributes which I can cross reference with each other.

id number, date, description, customer id, project , retailer id, price, invoice sent yes/no, paid yes/no.

Can you suggest a download link for a ready made database which I can edit to suit my needs please?

Re: advice on creating my first database

PostPosted: Sat Jul 07, 2018 2:25 pm
by Villeroy
Does not work like that. You need a little bit of theoretical knowledge, study some example databases, build some simple excercise databases on your own before you will be able to construct anything productive. "Intuition" will lead you to dysfunctional waste lands.

Resources: https://forum.openoffice.org/en/forum/v ... 17#p225017
Tutorials: https://forum.openoffice.org/en/forum/v ... m.php?f=83
Examples: https://forum.openoffice.org/en/forum/v ... .php?f=100

Base is not a database. It is a product to link various types of connectable databases with office documents.
Base comes with a very small and simple real database product called HyperSQL or HSQL. The databases produced by HSQL can be embedded in the Base documents. Any other type of database connection is linked to some tabular data source outside the Base document. In many cases a spreadsheet or text file is treated as a database so it serves as a simple source for a form letter.
In fact the "embedded HSQL" is a fake because it will be extracted when you start working with it and repackaged when you stop working with it. While working, it is just an external databsae like any other connection. This embedded HSQL is well suited for learning and exercising but not for productive purposes. However, it is fairly easy to turn it into a non-embedded, more secure version of a productutive database.

Re: Advice on creating my first database

PostPosted: Sat Jul 07, 2018 5:51 pm
by UnklDonald418
I uploaded a simple database that demonstrates something similar to what I believe you are needing.
There are 3 tables; Customers, Retailers, Tbl_Main and 3 forms. CustomerEntryForm and RetailerEntryForm use table grids to add/display/edit records in the Customers and Retailers tables.
MainEntryForm is used to add/display/edit records in Tbl_Main. It has 2 listboxes that allow Customer and Retailer ID values to be selected from the appropriate tables.

Demo28_Statements.odb
(37.66 KiB) Downloaded 127 times

Re: Advice on creating my first database

PostPosted: Sun Jul 08, 2018 2:37 am
by neiloneil
this is brilliant, thank you very much.