PK and FK not connecting

[JoeyB_99]

Well, very impressive speakers_86. Thank you. Quite a bit to take in.

I believe you have made my db in 4th Normal Form, is that correct?

How did you know to expand or normalize the tables and how far to do this process?

Does it have something to do with some data in the tables as static and some of it as dynamic? Also, how do you know which order to link the tables when you do this normalizing process?

I am about to proceed with constructing an input form with this new structure. I will report back on my findings.

Thank you speakers_86.

 

[speakers_86]

I believe you have made my db in 4th Normal Form, is that correct?

I don't know! I don't know the levels, I just know how to do it.

How did you know to expand or normalize the tables and how far to do this process?

Does it have something to do with some data in the tables as static and some of it as dynamic?

Basically. You've got two types of data, safety regulations, and reviews. Except for the foriegn key, these have nothing in common. That also explains why I named the tables the way that I did.

Also, how do you know which order to link the tables when you do this normalizing process?.

I'm not sure what you mean? Are you talking about the relationships? I don't usually even define relationships. I only did it here for your benefit. You can define relationships in the query.

 

[RainLover]

You can define relationships in the query.

Relationships can only be created in the Relationship Window.

A query creates joins. There is a big difference.

 

[boblarson]

UPDATE: When I click on the ellipsis for the Link Master Field and Link Child Fields in the property sheet of the subform I receive an error message "The expression you entered refers to an object that is closed or doesn't exist."

Just some additional info for you -

This error can happen also if you modify your subform in any way when the main form is open and then you go to click to set the master/child relationships. If you get that error, close the main form (and subform if open separately) and select SAVE for the changes you've made and then reopen the main form. It should then work again.