Order amend with details

[kabir_hussein]

Hi i am trying to do a function on my database where when an order is placed and it is then required for the order to be amended it can be done however the reason why, person authrised it etc must all be recorded.

I have been using the tables (check attached pic) and can not link the Order table with the order change table. what i need to do is when i print a report of i need to put down the orderchange number with the purchase Number. So this can be traked back for future use. But doing a query has not worked. Does anyone know a way which i could do this. I have attached the four tables involved in doing this task

Sorry if this sounds complicated.

many many thanks

kabir hussein

 

[Dreamboat]

If ya ask me, and I'm no Access guru, you need your order change table to relate to your Order table, NOT your PO table. It'll (ultimately) relate to the PO table through the relationship to the order table.

When you do the query, you'll need to have all 3 tables.