Relationship help

[floyd]

I have multiple tables and there are two that I am needing help with in regards to the relationship.



One of the tables has Course Information. (tblCourse).
The other table has File Information (tblFile)

I have a form which allows me to input new Courses. (no problem)
The File however is giving me fits!!

A file may or may NOT roll up to a COURSE.
The form I have to input FILE information will not let me continue unless I associate it with a course!

I don't WANT to associate everything.

I know this is very basic... but I am VERY NEW to Access.

I wish there was a course I could take... and am open to recommendations.

[orange]

It would help the reaer if you would define the things of interest to your situation.
We have no idea what a File represents in your "business".

I don't WANT to associate everything.

It isn't so much what you want to relate/associate, it really depends on your business rules/facts.

Here's a tutorial that may help you
http://www.rogersaccesslibrary.com/T...lationship.zip

Good luck.

[floyd]

I am sooo sorry.
I am new to Access and don't even know how to describe my situation.

Can someone review this and let me know if I am on the right track or if there is something that stands out as being REALLY badly set up?

It's the form (frmClass_File) that is giving me troubles.

[floyd]

I am NEW to databases and would love recommendations from those who know what they are doing. (I am not one of them!!!!)

I have two main areas.

tblCourse: This has specific course info:
1. Course Name
2. Course Description
3. Delivery Type (Can't change)
4. Course Topic (Can't change)
5. Course Audience (Can't change)

tblFile: These can be part of courses, or stand alone as an individual piece.
1. Item Name
2. Item Description
3. Item Audience (Pulls from same source information... can't change)
4. Item Topic (Pulls from same source information... can't change)
5. Item Type (Can't change)
6. Item Delivery (Can't Change)
This is linked by "Related Course" but as I mentioned... may or may NOT be linked to a specific course.

What do you see that is glaringly BAD???
I am having issues with creating "stand alone" files through my input form.

[June7]

How can a course have more than one topic, more than one delivery type, more than one audience?

You have loaded this design with multi-value fields. I NEVER use multi-value field. Whether or not multi-value fields are bad is subject to debate but most experienced db developers avoid them.

[floyd]

How can a course have more than one topic, more than one delivery type, more than one audience?

You have loaded this design with multi-value fields. I NEVER use multi-value field. Whether or not multi-value fields are bad is subject to debate but most experienced db developers avoid them.

THAT is a great call out and I have totally redesigned EVERYTHING!!!
Here is my new structure.

I hope this makes more sense.

[orange]

Did you visit the link I gave previously?

[floyd]

I have completely re-designed my database and would LOVE recommendations!

I have two main areas.

Courses: This has specific course info:
1. Course Name (txt)
2. Course Description (Memo)
3. Delivery Type (datDelivery)
4. Course Topic (dat_Topic)
5. Course Audience (dat_Audience)

Files: These can be part of courses, or stand alone as an individual piece.
1. Item Name (txt)
2. Item Description (Memo)
3. Item Audience (dat_Audience)
4. Item Topic (dat_Topic)
5. Item Type (dat_Item_Type)
6. Item Delivery (dat_Delivery)

I have these linked by junctions where appropriate.

What do you see that is glaringly BAD???
I am having issues with creating input forms due to the junctions.

[floyd]

Can someone let me know if I am on the right track?
I would hate to invest a lot more time on something that doesn't make sense.

[June7]

See related thread https://www.accessforums.net/access/...tml#post188140