Subforum Relationship with New Entry

[GADTG]

Hi all! Thanks in advance for any help with this.
I am a complete noob. I've dabled in Access a bit before enough to use a template to get our business a workflow system. But now we've grown... so the need for a more custom workflow system has as well.

Anyways, I am building our database after reading The Missing Manual. I surprisingly have everything but one function ready for use. And-of course- it is the biggie. Please forgive my butchering of the terms... I am very "fresh" with all this.

I have a Workorder Form that holds all the fields that apply to the entire project (payment, customer, etc).

Then I have a subform for Stock. This allows there to be several different stock items (and production information relevant to that stock) assigned to a Workorder.

I have successfully linked the two so that when a Workorder is opened, it shows any related Stock in the subform that has already been created.

The problem is new stock entries. I need it to only allow Stock additions to the current open related Workorder.

I currently have it where you can type in the WorkorderID (autonumber) on the Stock subform new entry and it will work. But I do not trust employees to type in the correct number every time they need to add stock to a Workorder. I can't release it this way.

I mean, the whole point is for the database to promote as little error as possible, right?

Once I have this *I believe* I'll be golden and can go into thorough testing... when I'm sure you'll see me again.

Thanks in advance again. I am in awe of the skill database programming requires, and I truly appreciate your time.

 

[jdraw]

Please post a jpg of your tables and relationships. You'll probably have to zip the file because of your post count.

 

[GADTG]

Of course! I'm assuming just open the relevant tables to show relationships?

 

[jdraw]

No. Go to Database ---Relationships
and it should open a new window with your Tables and relationships.

I;m not familiar with the Missing Manual, but hopefully it discussed Table design and Normalization.
If not work through this tutorial, which includes a solution, to get an understanding of database structure and how it all relates to the "business description".

Good luck with your project.

 

[GADTG]

Yes! I am familiar with relationships BUT for good measure I will read through the information you supplied. Thanks and I will get back with the requested info. Again, your help is SO appreciated- Thank you.

 

[GADTG]

I believe I attached a screenshot of relevant table relationships to this post (still new, let me know if didn't work).

Thank you for the information you sent. I went back to Normalization and read through ER Diagramming. Different terminology than I learned with, but great information and super reassuring to know despite language variables that the concepts are all the same (and I believe I have a descent grasp on it).

Just need to make it translate into my forms.

Please let me know any thoughts or suggestions. At this point I'm at a stand-still so my business workflow all depends on getting this to work.

Thanks x 100 again.