Somebody can traduzir English for Português, por favor?

Creating tables and queries
Post Reply
floristptbr
Posts: 4
Joined: Sun May 11, 2014 8:30 pm

Somebody can traduzir English for Português, por favor?

Post by floristptbr »

"Autotranslation (RoryOF, Moderator)
Read several articles and tutorials about Base and SQL .

I did setup my database , I looked and reviewed many points before creating tables .
In my work , are 29 tables, one for each flower species with which we work .
then: I made the tables and gave Base " Okay , all right."
I created the structures and relationships and Base gave " Okay , all right."

What's the problem then ?

The Panorama is :
1 ) That the Table 1 , adding 8,000 semesntes of acáci ; and Table 2 , adding 4,000 seeds etc. ...
- The sum of this number semestes in " Table 30 "

2 ) What , adding " ID_Flor " in the list of " Total_flores " I can already have the list of species of flowers ( collected from other tables filled ) , showing me the amount of seed of each flower ( clhida tables ) and in another column the sum of the seeds.

I do not know if I was clear , I will try to diagram in text :

Table 1 : Acacia
Table 2 : Jasmine
Table 3 : Tulip
Table 4 , 5, 6 ... etc.

The data in each table are : Species flower , flowering , seed amount , status
- The " status " field has separate table : status in bloom, in trciclo status , status in no flowers etc ...

I made a table relating the species of flower ( ID_Flor ) with the number of seeds ( ID_Sementes ) .
I made another table , with the stock , as ID_Flor and ID_Sementes , taken from Table mentioned above.

The intention is that : When padding the field " seed number " of acacia table , this value already filled automatically fill in other fields equal in other tables . That's what I'm not getting .

Fill " Acacia " in Table X and " Acacia " must also appear in Tables : Report , stock, input and output statistics , more propitious season; and another set of data from other tables . All data that fill in each table , must follow for one or more tables , so I do not have to open the Table of each flower and stay copying the data to the general tables .


---
Another problem I'm enfrentanso is in relation to the sums .
Tables of flowers and seeds have values ​​: " Unit " , " total in stock " and " expected revenue " .
Each flower has its calculation. However , I 'm still filling these calculations manually . Not found on any tutorial explaining how to make this sum ( " total in stock " " unit value " + ) = > " value of flowers in stock " = " predicted value of sales " = > ( " valorvendas " - " valor_custo " ) = " caixa_total "

I do not know if I explained right ( I think I created more confusion trying to make a scene ) but the problem is basically :
- Filled with data that are not going to all fields from other tables ;
- The sum of the fields that have to add up the table and send the current situation.

I thank those who can solve the riddle and help me with the solution ."

Agradeço
OpenOffice 4.1.0 in Windows 7 Ultimate (desktop)
floristptbr
Posts: 4
Joined: Sun May 11, 2014 8:30 pm

Re: Somebody can traduzir English for Português, por favor?

Post by floristptbr »

Acho que estou levando uma bronca por não saber escrever em inglês mas para um brasileiro normal já é difícil, para uma deficiente é mais difícil ainda...
Peço desculpas se infrinji alguma regra. Eu só queria aprender para poder resolver sozinha outos bancos de dados em Base.
Novamente, peço desculpas...
OpenOffice 4.1.0 in Windows 7 Ultimate (desktop)
User avatar
floris v
Volunteer
Posts: 4633
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

Re: Somebody can traduzir English for Português, por favor?

Post by floris v »

Você deve escrever em Inglês neste fórum ou fornecer uma tradução do Google com o original (no caso a tradução é um absurdo). Infelizmente, não parece ser um fórum língua portuguesa para AOO.

You should write in English in this forum or provide a Google translation with the original (in case the translation is nonsense). Unfortunately there doesn't seem to be a Portugese language forum for AOO.
LibreOffice 25.8.4.2 on Ubuntu Linux
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
floristptbr
Posts: 4
Joined: Sun May 11, 2014 8:30 pm

Re: Somebody can traduzir English for Português, por favor?

Post by floristptbr »

Sorry.
Não sabia que tinha pé-requisito pra tirar dúvida no forum. Aparece na minha busca como fórum oficial, deduzi que atendiam a todos.
Tentarei em outro local.
Desculpe pela incoviniência.
OpenOffice 4.1.0 in Windows 7 Ultimate (desktop)
Post Reply