Search results

many thanks for that, so simple when you know how

how do i get form to generate a new ord ID for the same customer in my orders table

HI alan many thanks for replying I am entering via a form not sure if bound ? I highlite orders table and create a basic form using the wizard I now realise that when i choose an existing customer ,instead of creating a new ordersID it simply updates the original orderId with current date ect...

Thanks for previous answers I am a newbee and struggling to make thingsd easy for me to understand .I have created two tables customers and orders . related together all seemed well untill i tried entering an order for an existing customer it wont update the orders table with the cuid if i enter...

Hi really struggling but wont give up I have 4 tables Custumers ,Orders ,Order details ,products i have related the tables in above order have created forms for all above tables using acces ref guides ,but still cant get it to work properly i create the new customer were do i go next...

Hi I am a complete beginner all was going well i have a data base that works .but i have hit a problem that must be stupidly easy to solve I have a customer table and a order details table i have a check box in order details table . I want to find all my customers who have never ordered ,so i...