need help in access

[muhammed361]

what i want to achieve is i want to make a list in Inventory_table of item name,part no,price,color details,size etc. and in another table orders_table i would like to put a lookup in first column so when ever i type in the part number in that colum all the detailes related to that row in inventory_table should appear in order_table and i want to be able to make changes in order_table, not in inventory_table. And i want to store this order_table as separate, I mean I don't want a query lookup to just see the info ! i wanna be able to modify the data and store it in order list.

How can i achieve this without using VBA or Macros ?

[andy49]

Why is my first question.

Surely easier to choose a part number and the form shows all the relevant values for that part using a query based on joined tables?

Your database won't be normalised as you'll be storing the same data in two different places.

Unless I missed something?


Sent from my iPhone using Tapatalk

[muhammed361]

Why is my first question.

Because It will work as sales orders in my shop.
Inventory will store all the information of the products. so when customer comes i will inser the part number of the data and it will show all the details from inventory and i will make changes in order list according to the customer's needs i.e my customer would like to buy rose gold iphone, then this order list will be displayed in the warehouse from there the warehouse keeper will see the new order and he will send the product to the sales shop.