Hello Richard.

I'm writing to you to ask you if you have any suggestions on how to add another field to the iform which would be  to be fed by another table which holds my prices for items which can we put onto the form and work out my cost all materials as I make pay invoice for a job

As you know when we made the invoice in expert level 8 which was made from order details table.

So what I'm trying to workout is how to feed I field which only shows up in the form not that invoice

I am able to work out but total cost to me for that job why I am thinking about table would hold all the prices which cost me.

If you're not 100% sure what I am asking you if you had a quick look at my database or go and have a look at expert level 8-9 showing you how to build us which you put together I think in 2011 because if I just added that field to the form it would need to be fed by the query which we made from memory at was order details Q but how would it get the correct price for that field when it needs to be

I want to work out the price add a does currently to get the line total this has been must've flying me for months since I realized we need to do this but as I said how do you feed that one field weather different table but get it to work out the correct title line total as you enter each item for example if I put them DVD discs instead of showering just the price to the customer that would show me the price to  me sorry if this has been a bit long winded you may have already have a video showing something like this but I can't find anything on your website

Michelle