Problems creating form and relationships

Discuss the database features

Problems creating form and relationships

Postby terentis » Fri May 10, 2019 2:24 am


I've been trying to make this for the past week watching tutorials but I keep on running into same errors and i'm running myself into a wall trying to figure this out

I'm trying to make a table to keep track of sales for a small business that ive started and want to beable to generate a report to show the profit i'm making from my sales but everytime i try to make a form to help show this it doesn't work. I've tried to make relationships to make this work but I keep on getting several different errors depending on how i try to make those relationships. the relationship that i can create never seems the same from ones i see in the examples posted online as well so im really over my head.

i want to have a form to keep a list of the items i have for sale with fields for

and a table to keep track of each transaction i make
qty sold

and then make a report to show the profit i make from the retail/cost fields for either a year length or a specific month

i can create the tables fine but when i get to the form for the transaction i cant seem to make it work

ive included what i currently have made and was hoping someone could wave a magic wand and fix my problem so that i can learn from my mistakes

ps, if this doesn't belong here i apologize
bgn shop.odb
(19.17 KiB) Downloaded 138 times
openoffice 4.1.5 windows10
Posts: 1
Joined: Fri May 10, 2019 2:12 am

Re: problems creating form and relationships

Postby UnklDonald418 » Fri May 10, 2019 6:11 am

Look at this example.
[Example] Invoice Forms (without macros)
You might be able to use this as a starting point

Here is a database design tutorial you might find helpful
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.6 & LibreOffice - Windows 10 Professional
Posts: 1326
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Return to Base

Who is online

Users browsing this forum: No registered users and 7 guests