Recent content by Ctang

  1. C

    Enter data into multiple tables from one form

    Hi June7 The error message is "you cannot add or change a record because the related record is required in table customertbl' . But I don't want to add or change anything in that table, all I want to do is add the transaction details into the transaction table.
  2. C

    Enter data into multiple tables from one form

    Hi, really sorry about this. I have tried to re-create the answer provided (which by the way was fantastic) however whenever I try it I keep getting an error message! Please help! I have attached my poor attempt at it.
  3. C

    Enter data into multiple tables from one form

    Thank you so much both of you for your help. I will now get my head around this so I can teach it to my students. Once again, thank you very much I really appreciate the help.
  4. C

    Enter data into multiple tables from one form

    Hi, I have uploaded the database as it stands so far. All the data inside is fictional. You will see two forms - sales and part exchange, which have really stumped me. I really appreciate the effort everyone has been putting into my problem. Here's hoping for a quick solution!
  5. C

    Enter data into multiple tables from one form

    Hi June7, I tried your solution with my students but they just cannot understand it, is there a way to do this without having to code?
  6. C

    Enter data into multiple tables from one form

    Thank you, I will give that a try now
  7. C

    Hello

    Thank you both for the welcome. Pbaldy I feel it's my job to make sure my students are taught enough skills so that they can gain the top marks and that I am able to troubleshoot if required. Thanks
  8. C

    Enter data into multiple tables from one form

    I created a form with sub forms, but it will only enter data into the stock table. I keep getting an error message telling me the customer does not exist and the transaction table remains empty
  9. C

    Enter data into multiple tables from one form

    Hi, just wondering if I could have some help. I have created a 3 table relational database about car sales. So a customer table, a stock table and a transaction table. I would like to create a transaction form that will allow me to add the data into all three tables, but it will only allow data...
    • Ctang
    • Thread
    • Replies: 21
    • Forum: Forms
  10. C

    Hello

    Hi, am a teacher in a relatively small town called Doncaster. I have been teaching Access on and off for approximately 16 years, but not very high level stuff. I have joined hoping to advance my skills as the curriculum seems to be asking for more advanced Access skills from my students all the...
See more
Back
Top Bottom