K
kamil.jedrzejewski
Hi.
I've got an Access db which consists of tables, which are downloaded
from our AS400 system.
I need to have it in mdb because I can't do any modifications in AS400
db, secondly Query/400 is not enough flexible for me.
Tables in mdb:
SM (stock movements)
ST (current stocklisting)
PI (purchase invoices)
SI (sales invoices)
I want to add values to each stock movement. Values are only in
invoice files.
Some movements can only be valuated manually.
Details on tables:
SM table consists of:
-SKU (product key) (PK)
-date (microsecond level)
-quantity
-...
-ordernumber
-orderline
PI table consists of:
-invoicenumber (PK)
-invoiceline (PK)
-SKU
-date (day level)
-value
-ordernumber
-orderline
-receipt number
-...
As you can see, there is no common key.
I'm thinking about linking by ordernumbers/lines, but it's not unique
in SM table (multiple receipts).
Do you have any idea how can I link these tables to have values in SM?
Best regards,
Kamil
I've got an Access db which consists of tables, which are downloaded
from our AS400 system.
I need to have it in mdb because I can't do any modifications in AS400
db, secondly Query/400 is not enough flexible for me.
Tables in mdb:
SM (stock movements)
ST (current stocklisting)
PI (purchase invoices)
SI (sales invoices)
I want to add values to each stock movement. Values are only in
invoice files.
Some movements can only be valuated manually.
Details on tables:
SM table consists of:
-SKU (product key) (PK)
-date (microsecond level)
-quantity
-...
-ordernumber
-orderline
PI table consists of:
-invoicenumber (PK)
-invoiceline (PK)
-SKU
-date (day level)
-value
-ordernumber
-orderline
-receipt number
-...
As you can see, there is no common key.
I'm thinking about linking by ordernumbers/lines, but it's not unique
in SM table (multiple receipts).
Do you have any idea how can I link these tables to have values in SM?
Best regards,
Kamil