Search results

thanks very much works a charm now you have done it i can see what needed to be done thanks

Yeh they shouldnt be there really, it was from previous messings around with or something :) the phones table should have the stock level - THE actual stock level the order bit, i just want to fetch the stock level from the phones entity when the respective phone is selected in the order (eg...

DCount(Stock Level, Phones, [criteria]) Have I got the first two kinda right Stock level being the expression of what I want to get the value of, Phones being the table I want to get the expression from?

SO it would be along the lines of??? DCount("Talk Plan Id" And "Phone Id", "Order Id = [Order].[Order Id]") So it will be bringing the order id value from what is the current order id number? i think

Where the arrows are I want to select talk plan, then the phone model Upon selecting phone model, the relative stock information should then be fetched for that phone model I am a complete beginner at this Here is my query and relationship table

Hi guys/gals I have managed to work out a query, so when a product is selected for order, it will fetch the necessary stock level for that product into the stock table. Thing is, I use the order table credential "Phone ID" which is a lookup as a query item, so the query looks for what is...

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

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...

oh dear. seems i have been taught wrongly so if i delete all relationships, remove all lookups in the tables (basically have no relational data) up until the forms and then start setting the lookup relation unless i can still have a relationship but without the lookup table (using the...

Hey I want my lookup table to show more than the initial entity in a field (think i got the right words there). As you can see I need to have more than the manuf showing so i can double check orders etc. Thanks

Hey I am creating an inventry system and so far so good for a beginner. I have created an ordering system, extremely basic which is getting there. I need to be able to add the total cost up to the footer of the subform which I will then use to create invoices etc. Once I have that...