Question Access 2007 link stock to product

[mrapoc]

Feel free to move if in wrong place

I need to design a database, storing customer details, taking orders, different talk plans, different phones and different manufacturers

I want it so when making an order, you select the phone, and talkplan (done this already) but it also fetches the stock level associated for that phone (i only really know how to do lookup tables kinda thing)

Bit of help please

View attachment Phone Database.accdb

Thats what I have so far, probably terribly noobish but I'm not too Access experienced

Thanks

 

[mrapoc]

Edit:

Realised I i didnt need a seperate stock table, so stock is only present in the "phones" table.