this is driving me nuts

[Raleyoz]

I am a NOOB



im sure this is easy but i can not get it done and i need to move on

i have a "product" that i sell which i have entered into a table called "Products"

i would like to create a table to "order" that product, on that "Order" table i would like to lookup the product from the "products " table and retrieve several items from ther "product table , such as Product code, product price, Product qty per case.

i can get it to show 1 item but the rest will not auto populate, AAAAAAAAAAAAAAAAAAAugh

help

[ItsMe]

...i can get it to show 1 item but the rest will not...

What is this thing that is showing the 1 item?

[Raleyoz]

Ok my product table has
ProductID
ProductCode
ProductName
ProductSupplier
Age

On the new order table, I would like to select a product to order and the relevant data from the product table auto populate the new order table or form

Hope this makes sense
Tony

[ItsMe]

I think it makes sense. It sounds like you have one table and nothing else. Your question is, "What do I build next to create new records in another table?"

I would create a form that opens in data entry mode and is bound to this second, new, table. I would use a combo that queries your first table to add the product ID in the second, new, table.

[Raleyoz]

Thx for your response
I actually have both tables created already, and I know what I want them to show
My order table has these fields
Order number
Product code- lookup from the product table
Product name - auto populate once product code is selected
Product cost- auto populate from product table one product code is selected
Etc.

[ItsMe]

All I can do is guess what your question is. Putting your question aside, your second table does not have the correct structure. Store the Primary Key value from your Products table in the Foreign Key field of the Orders table.

tblOrders
OrderKey (Autonumber)
CustomerKey(Long Integer)
OrderDate(Date)
etc

This video may help to explain how to get your tables in order.
https://www.youtube.com/watch?v=-fQ-bRllhXc

[Raleyoz]

My question is as it stands in the first paragraph, it appears you do not understand, but thanks for trying

[CJ_London]

I think we understand you are a 'NOOB'. You need to understand that you do what you want to do through a form, not a table

[Raleyoz]

Great that's how i tried to do it originally,l but yet I still cannot achieve this. I can bring down one piece of data but not 3 , or 4 pieces from the table

[CJ_London]

you've told us the content of your products table - what do you have in your orders table?

[Raleyoz]

I would like to fill out a form to complete an order
Order ID
enter SKUCodes from products table
auto populate ProductName
auto populate ProductPrice
Enter Quantity to order
calculate Price
Add additional SKUCodes to order

[CJ_London]

I wish you would just answer the question - what do you have in your orders table at the moment?

auto populate ProductPrice - where do you get this from? - it is not in your products table.
calculate Price - if you are autopopulating, why do you need to calculate? and if you mean a line value (productprice*quantity) please be clear about names

If you want concise answers, you'll need to provide concise information.

[Raleyoz]

Sorry i thought i was

Orders Table
WinePurchasesID
SKUID
SKUName
SKUPrice
CaseSize
CaseQty
ContainerNumber
ValueOrder

I wish you would just answer the question - what do you have in your orders table at the moment?

auto populate ProductPrice - where do you get this from? - it is not in your products table.
calculate Price - if you are autopopulating, why do you need to calculate? and if you mean a line value (productprice*quantity) please be clear about names

If you want concise answers, you'll need to provide concise information.

[CJ_London]

and the answer to my other question?

auto populate ProductPrice - where do you get this from? - it is not in your products table.

[Raleyoz]

auto populate ProductPrice - where do you get this from? - it is not in your products table.
yes it is in the products table