Lookup for two columns in data verse table
Dears I created a table named "onboarding employee" I made a column name "Sector name " and the type is choices, which are (Production sector, Support sector, ...) I created another table named "All Jobs", this table has two columns "Sector name" and "Job title" and each sector has some job titles like the below photo I created a new field in the "onboarding employee table " named "Job title " My request is when I select a sector from the "sector name field" like the production sector and then when I press on "the Job title field", it shows me only the jobs related to the production sector what can I make this? Thanks in advance
Need help with Relationship Diagram
Hello! 😃 I'm very new to Microsoft Access and I'm trying to build a system for my small school to help keep track of all our student's monthly course registration and payments. Can somebody point out any mistakes or improvements that I can make to this Relationship diagram please? I'm at my wits end lol I would really appreciate any help! Cheers, Ben
PivotTable : Unexpected behavior with 2 tables
Hi, The first picture shows the expected behavior of adding 'Product' and 'Revenue' to a pivot table. Now when i add the same fields but from 2 different tables linked with a relationship, the result is different (please see 2nd picture). Could somebody explain this weird behavior ? Thanks in advance PivotTable with 1 table PivotTable with 2 tables Relationship
