Search results

I have a lookup on a table that calls ProductID, ProductName and ProductCost from tblProducts. The lookup is on the field ProductID on tblBasket and when the item is selected it displays the correct value. However when the item is selected i need to take the ProductCost value from tblProducts...

Well at the moment i'm still in the design stages, but i made a database with test fields to see how it would work out best. Basically i have to have a form with a drop down list for each type of computer componant and when selected the total price for all the items selected so far needs to...

Hello there, some help would be nice! Say i have a booking field. If people wanted to book a number of seats, how would i make it so that when the number of seats that was entered on the booking form was entered it would add on to the exsisting number of seats taken? So say for film A There is...