Not sure how to set relationships after splitting table (3 Viewers)

[ilikecats]

Attached: A stripped-down version of my database.

In tblPlayableSims, I have several columns that I split into their own tables - if I have two Sims with the same job, I don't need to store the information separately for each. I related them like this:

https://imgur.com/TxCeX3v

However, now I'm not sure exactly how I should link this to tblPlayableSims - do I set relationships to one or both tables, or to the query qryCareers?

Additionally:

In subfrmPlayableSims, in the Careers tab, I still have everything linked to my old columns.

https://imgur.com/Qf9q6Ov

(Note that 'Gets Promotions', 'Days Employed,' 'Take-Home Salary', and 'Vacation Day' are still part of tblPlayableSims because the information is specific to that Sim.)

Ideally, I wanted to change some of the textboxes into comboboxes to create a cascading combobox - first select 'Science' tblCareer, which would then filter a second combobox so that I would select either '2' or 'Test Subject' and have the other fields automatically populate.

I hope I'm clear about what I'm trying to do, and thanks in advance

 

[plog]

Its not clear, mostly because you spoke with too much database jargon and not enough about the actual system you are trying to model. What's a playable sim? How does a job type have a career type? How's a job different from a career? I need context of what is represented to understand what the tables should look like.

With that said, I can help get you there. You assign direct relationships to the most granular level. Car analogy: In a Cars table you wouldn't store make and model, just model. Then your Model table would hold the Make.

So most likely playersims is related to just jobs. And careers is linked to just jobs as well

 

[ilikecats]

yes, that makes sense.

In the Sims games, a career track is basically a set of related jobs - e.g. the Science career has 'Lab Glass Scrubber' and 'Top-Secret Researcher' as two options for the job. A Sim can only hold one job at a time.

Additionally, there's actually two separate careers named Science - one for full-time and another for part-time. So the 'career type' column I use to differentiate the two for sorting purposes and the like.