Search results

  1. E

    Forms that update/create records in multiple tables, including junction tables

    Thank you, much appreciated. I have a subform set up, but I'm not sure how to input things into the junction table. This is what I have so far. I managed to use a SQL query to fix what i wanted in edit 1, and just to confirm, for row source, i now have: SELECT Inventory.Book_Title FROM...
  2. E

    Forms that update/create records in multiple tables, including junction tables

    Thank you, I'll be going through that shortly. Do you have any specific suggestion as to where to start with regards to my problem? And I'm pretty sure my database is 3NF, which is sufficient for Access, am I incorrect? I think I can achieve 4NF but again, having the employee table separated is...
  3. E

    Forms that update/create records in multiple tables, including junction tables

    Hi all, access noob checking in. So I have a database for a project that is simulating a used bookstore's database system. My relationship table is attached below. Please forgive the lack of normalization on the 3 type of employees on the right side, it's a specific project requirement. I...
Back
Top Bottom