Tracking Vendor Issues - Access Developer Forum


	Back to Access Developer Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Tracking Vendor Issues

James White

4 years ago

I have multiple vendors that have compliance issues, some may have one compliance issue and others may have many compliance issues. I want to be able to track each issue per vendor separately. As an example, VendorA-Out of compliance with section 1 of the contract (this is one issue), VendorB-Out of compliance with Section 1 and Section 2 of the contract (these are 2 issues for this one vendor)

	Adam Schwanz @Reply 4 years ago
Do you have a problem you're encountering or is there a question you need help with? Try Many-to-Many and Relationships

	James White OP @Reply 4 years ago
No problem encountered. Is there a way to track the above?

Adam Schwanz @Reply

4 years ago

Sure, lots of ways you could do it. It's not so easy to blindly advise you if you haven't started the project and don't have any problems yet though, I don't know what you're doing for sure or what you want to do with your database. Watch those 2 videos, a relationship is going to be the core behind tracking the issues to vendors.

If you're just creating an issue or "ticket" and then assigning a problem to it, you can use a one to many.

if you're assigning pre-set problems (Section 1 Contract for example) to vendors, use a many to many

	Adam Schwanz @Reply 4 years ago
Help Desk might help as well. It's the same idea, assigning tickets to customers.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Forum.

Next Unseen

New Feature: Comment Live View