I hope to look at the database

[azhar2006]

Hello all
Let me
I hope to look at the database
And advise me
Are the tables are correct
Is correct relations
What is wrong with


Thank you

[ItsMe]

What were your plans for the field named "DateOpin" in tblGroups? I do not see that field in the table. The field is in your query though.

The table named, "Silver" does not have a Primary Key. Is this table to privide a list of options to the user when they are selecting a value for Calibre?

[azhar2006]

Thank you ItsMe
1. Is the date of purchase by the customer for silver
2. Yes
If you look good you will see a query
The silver ounce sold on Europe
As for Asia, there is no silver ounce sold
Do you set up another table for silver or what?

[ItsMe]

Do you set up another table for silver or what?

I am not sure at this point. I will be pretty busy today. So I will not be able to spend very much time on your database today. You may be able to track regions using another table for regions. This may eliminate the need for another "Silver" table.

When I get a chance to look at your database again I will add a date field to the table so I can get a better idea of how you intend the database to work.

[azhar2006]

Thank you very much ItsMe
I am very happy for this news

[ItsMe]

I can net get the forms to function as they are now. I added a new field to the table for the missing field named, "DAteOpin" to tblGroups. THis allowed me to open the form named, "frmSilver" but the form does not provide any functionality. I noticed your forms are using subforms. Using subforms is not a bad thing. However, using subforms that are within other subforms should be used for special occasions. YOu may want to consider an alternative method to your subforms.

Before you can create functioning forms you need to have your tables correctly structured. The tables NameSelvir, tblGroups, and Silver may need to be reassesed. It may be beneficial to combine these tables into one or two tables. Perhaps if you combine them into one table, a few of the fields could go into tblOrderDate. If that is not an option, consider combining the three tables into two tables. The idea here is to cary over the primary key values of these tables that describe the silver to your tblOrders table in the form of foreign keys. You want your tblOrderDates to log the events of sales and each record within tblOrderDates should have as many details as possible. Doing this first may provide a solution to keep track of inventory in yet another table that does not yet exist within your database.

[azhar2006]

Thank you very much ItsMe
1. And how is this table tblOrderDates
2. There are two drawbacks of silver
Silver ounce sold on the price for the day (the Silver Europe)
Silver sold at market price, not the price of ounce (a silver Asia)
3. Are queries correct?
4. How are recycled profits from money to silver (the reverse process)

Is it possible to get an example

[ItsMe]

The distinction of which market can be managed at the time of sale, in the tblOrderDates. tblOrderDates will need more fields that include the foreign key values of your other tables.

You are going to need to focus on one task at a time. Perhaps a better aproach is to start with your inventory. Determine how to track your inventory and then worry about the sale. Do you have an example of how you track inventory? Perhaps a spreadsheet?

[azhar2006]

Thank you ItsMe
Can I set up a query
1. To pull sold from silver from the day of the total stock in the table of silver
For example, there are silver in stock 1600 g
2. But the problem is
How is the sale of silver in the store on 12/10/2013
And leave the silver in the store which is present on 08/08/2013
3. In the query in the picture attached
You can not filter action of a certain type of silver
So I can create a query for this special silver

[azhar2006]

Thank you ItsMe
Can I set up a query
1. To pull sold from silver from the day of the total stock in the table of silver
For example, there are silver in stock 1600 g
2. But the problem is
How is the sale of silver in the store on 12/10/2013
And leave the silver in the store which is present on 08/08/2013
3. In the query in the picture attached
You can not filter action of a certain type of silver
So I can create a query for this special silver

[ItsMe]

it seems you may be working harder than is needed. Creating a query when the tables are not yet defined will not be productive. How do you currently keep track of your inventory? Do you use paper and pencil to keep track of your inventory? Do you use Excel to keep track of your inventory?

[azhar2006]

Of course not. ItsMe
Ha ha that's how I used a pen and paper
Why am I hired you sir
I'm really in the way of closed
I do not know why I work
I'm here at the Crossroads
How can I manage inventory

[ItsMe]

I am missing a lot of our conversation in the translation of our languages. I will take another look at your DB and see if I can propose an inventory table. I will also look at your previous threads to hopefully gain additional insight.

I would like to point out that the word, "hire" implies there is monetary compensation involved. I would like to make it clear that I am not trying to help you for monetary gain. I do not seek monetary gain personally or otherwise.