M
marko
I have a database of shoes which has prices,brands,models,colours and
an ID(primary key),without sizes and quantity. This is something like a
database for a shoe description. Then i have a database for each store
and one for my warehouse. These databases only have ID(primary
key),quantity and sizes. So this is an example: ID:12931 Quantity:23
Size:45 (I'm from Croatia)
The ID of stores are linked with the ID of the main database. Now i
would write the status of shoes in all my stores and the warehouse. And
at first everything and need to do is update the status in my stores
and warehouse.
THIS IS MY FIRST QUESTION:
when i'm writing the status in my form for
a store or warehouse I can only see the ID,quantity and sizes but i
would also like to see everything from the main database because i
linked the stores and the main database. But i don't want to write
everything in it. I would like the form to have
everything:ID,prices,brands,models,colours,size and quantity. But if i
write the ID(which is one of a kind for each shoe) i would like the
other fields
rices,brands,models,colours to fill in automaticly
because they go with that ID, and i would now write the size and
quantity and that's it.
THIS IS MY SECOND QUESTION:
i would like to have one form in which i can select from where to where
transactions. For example:We are making a shipment from the warehouse
to one store,then I would select the warehouse and one of the stores
and write the ID for each shoe,quantity and sizes and the status of
that shoe would decrease from the warehouse and increase in that store.
And i have multiple stores so i would like to have an option to which
store i'm distributing shoes and also i would like to have an option to
distribute shoes from one store to another and also from stores to the
warehouse.
And i would like to have one form for sales so i would write in what is
sold and then those pairs of shoes would disapear from my database in
that shop.
Please help,or if you know any good tutorial that has answers to my
questions will you please tell me.
By,
Marko
an ID(primary key),without sizes and quantity. This is something like a
database for a shoe description. Then i have a database for each store
and one for my warehouse. These databases only have ID(primary
key),quantity and sizes. So this is an example: ID:12931 Quantity:23
Size:45 (I'm from Croatia)
The ID of stores are linked with the ID of the main database. Now i
would write the status of shoes in all my stores and the warehouse. And
at first everything and need to do is update the status in my stores
and warehouse.
THIS IS MY FIRST QUESTION:
when i'm writing the status in my form for
a store or warehouse I can only see the ID,quantity and sizes but i
would also like to see everything from the main database because i
linked the stores and the main database. But i don't want to write
everything in it. I would like the form to have
everything:ID,prices,brands,models,colours,size and quantity. But if i
write the ID(which is one of a kind for each shoe) i would like the
other fields
rices,brands,models,colours to fill in automaticlybecause they go with that ID, and i would now write the size and
quantity and that's it.
THIS IS MY SECOND QUESTION:
i would like to have one form in which i can select from where to where
transactions. For example:We are making a shipment from the warehouse
to one store,then I would select the warehouse and one of the stores
and write the ID for each shoe,quantity and sizes and the status of
that shoe would decrease from the warehouse and increase in that store.
And i have multiple stores so i would like to have an option to which
store i'm distributing shoes and also i would like to have an option to
distribute shoes from one store to another and also from stores to the
warehouse.
And i would like to have one form for sales so i would write in what is
sold and then those pairs of shoes would disapear from my database in
that shop.
Please help,or if you know any good tutorial that has answers to my
questions will you please tell me.
By,
Marko