Help with Relationships Please?

[silent]

I am having some trouble with parent/child relationships in my tables. I know what I need them to do, I just can't get it done. Please help!
see attachment:

I need my tblDescription to be the parent.
I need tblchecks to branch from tblDescription.
I need tbllocation to branch from tblchecks to make everything jive in my world.

Thanks to anyone that can help,

 

[silent]

The changes to this database were pure. I change every single column of every single table. It is poor practice to use embedded spaces or special characters in your column/table names so I removed them. I removed the extraneous indexes. When making relationships between tables, you store the prirmary key of the one-side table in the many-side table. I recommend using the same name so it is easy to identify the relationships when you look at the tables. So, I removed all the duplicate data fields from the location table and replaced them with the ID fields since those are what must be used as the foreign keys. And finally, I enforced RI.

I have no idea if what I did was correct. I made the relationships based on what you said in your post and what data was duplicated.

I also set the db to compact on close.

Thanks, so much for the help.

I do have one more question, in my tblDescription, the field Checks needs to be a combo box. Is there a way to fix that?

 

[nst]

Don't make it a combobox in the table. Make the combo in the form. Lookups in tables simply get in the way when you make queries or process the recordset with code.

How can this be done?

 

[neileg]

How can this be done?

There's a combo box wizard that takes you through the steps.

 

[nst]

Found it! Thanks.