Need Help Defining Custom rows in access table

[muhammed361]

Basically I need to define 3 text boxes and then what i type partnumber in textbox1, textbox2 and textbox3 should get its data from table1 and display it and then save that data to table2.



Oh BTW this is for MS ACCESS.

[orange]

Step back and tell us about WHAT you are trying to accomplish in simple, plain English --just as you would tell an 8 yr old.
No jargon, and no quasi database terms until we understand the business issue you are trying to resolve.

[muhammed361]

OKAY NOW WE'RE TALKING....

So Basically I need a sales order tracking inventory list.

1) I need one table in which i have 4 columns column1 = unique id, column2 = product name, column3 = model number, column4 = price
2) I need one more table which has 4 columns but without any data in it. so when i input a unique id in column1 it should fetch its details from the table which has product details so this way i can input multiple unique ids and at the end generate total amount of all those products purchased and then print its bill with all its details.

[orange]

Possibly, but it sounds like you have suggested HOW, not what.

It seems you have various pieces of equipment and each unit has:
-a unique serial number
-a model number and
-price

There is no information related to the Date of Purchase or Sale
There is no allowance for changes in Price

It isn't clear if you are buying equipment, selling equipment or buying and selling equipment.
Also, there seems to be no info related to a typical business where you buy equipment form 1 or more Suppliers;
or where you may sell equipment to 1 or more Customers.

There is some business context required to put these pieces together. You mention Sales and Orders but have not shown how these fit in your set up.

Good luck with your project.