Hi! This is my first post. I want to build a sales project via access 2003. I've created 2 tables named
1.PRODUCTS (fields- PRD_CODE, PRD_NAME, PRICE)
2. SALES (fields- MEMO_NO, DATE, PRD_CODE,PRD_NAME,PRICE)
I made relationship so that the PRD_CODE from SALES table must match with PRD_CODE with PRODUCTS table.
Now, I want that- when I will input the PRD_CODE in SALES table, the PRD_NAME and PRICE fields will be automatically filled up with values from PRODUCTS table's PRD_NAME and PRICE value.
I've created form for SALES table. I don't know what code to write at AfterUpdate() in PRD_CODE field.
Please, Help me.