I can't get the correct relationships in my database

[magic_andrew]

Hi,
I've created a database which I think I've normalized (correct me if I'm wrong) and I'm sure I've got the relationships correct. However, when trying to implement this in access, I can't seem to get the relationships to match up. Any help?

[Rawb]

I can't speak to normalization without knowing more about what all the Tables are for, but the two Tables tblWeekOrders and tblPeriodWeeks look a little shifty to me. Can you explain a little more about what exactly your database is for and what the purpose is for each Table?

Also, you shouldn't use question marks or percent signs (or anything except letters, numbers, and the underscore) in Column names.

[magic_andrew]

I'm using it in conjunction with a VB form to enable a user to edit it via the form. Here's how it works (let's just say we're doing it directly in Access):
tblOrderDetails and tblCustomerDetials is pretty self explanatory. CustomerID is the name of the customer/company rather than a number assigned to them whereas OrderID is a number entered by the user.
tblWeekOrders is the linking table (I think). It shows the Orders, which customer they belong to and what Week (1-4) in the 'Period' (1-13) they are going out.
tblPeriodWeeks is the one, unsurprisingly, I'm unsure about as well. It's meant to be able to differentiate between week 1 in period 1 to week 1 in period 2 for example. The user would also have to enter which period the order is in.
Hope that helps. It's hard to explain what I'm trying to do :S

Here's an attachment of the database:
https://drive.google.com/file/d/0Byk...ew?usp=sharing

[orange]

Andrew,

I agree with Rawb -your tables are suspicious.

Don't use anything but alphanumerics and underscore '_' in table and object names with Access. It will save you a lot of frustration and wasted time with syntax errors.

You should work through this tutorial to get a better handle on normalization and table design. You'll learn more in an hour than doing trial and error for a few months.

Also, here are some free video tutorials that will help with concepts of normalization etc.
Work through the tutorial and watch the videos, then go back to your database design with what you have learned.

Good luck.

[ssanfu]

Pay attention to the sections on Primary Keys and Foreign Keys........

[pbaldy]

Post 3 was moderated, just approved.