Am I using Access Correctly?

[MakinBacon91]

Hello All,

I am new to Access, and I am starting to figure things out, working up to designing a database for my company.

I am wondering if I am going in the right direction, or if it is plainly obvious to someone more experienced, that I will have problems down the road.

Here is a screenshot of my Relationships View: Pasteboard — Uploaded Image

Let me know if I need to explain anything to help you understand what I am going for.

Thanks,
Bacon

 

[Kyle123]

I didn't say you couldn't use a separate field as a primary key, but what's the point? A composite does the job more succinctly

As to the guid, they're useful when you have to merge databases - you can't import autonumbers into existing tables as you get conflicts. This is a pretty rare scenario, but it does happen so if there's a chance of it occurring it's best to think of these things in advance.

 

[Kyle123]

Apologies that came across as argumentative, that wasn't the intention

 

[HiTechCoach]

Apologies that came across as argumentative, that wasn't the intention

No problem. I took it as passionate.