These two tables will contain the bulk of my data, any additional tables could use the combined PK method.

If I decided to go with the combined PK method, how...

Yeah, that makes sense, and it's simple. I really hate it when these things aren't as complicated as I think they are.

Thanks, I will try that.

Well, I have different types of assets I want to track in each table, I don't want them all in a single table.

If that doesn't answer your question, could...

That would be why then.

What if this option is grayed out?