Filtering in a Form

[RammerJammer1674]

Hi everyone,

I have a form I'm using to create Job Numbers.

All of my table are normalized and everything, I'm just having trouble filtering.

I have a Table called Customer Type and a Table called Customer Information.

Customer Information has a Customer Type lookup. Customer Types are either Business, Residential, or Contractor.

On a form called New Job Numbers (Yes, I do have a Job Numbers Table), I have a Combo box that will select the Customer Type. I need a Combo Box that will select the Customer based off of the Customer Type.

How do I accomplish this? I would like to do this through the Record Source using a query. Anyone have maybe a sample or something? Thank you!

 

[jdraw]

Please post a zip file of your tables and relationships.

 

[RammerJammer1674]

Here you go.

Sorry, I had to make sort of a generic database.

Also, my Purchase Orders Details Forms needs to be continuous which is no problem, and it will be a subform in the New Purchase Orders Form. It needs some filtering as well. The Items in that Forms needs to be filtered by Manufacturer part of the form.

This is probably a mess to you, but this is my first ever database!

 

[jdraw]

You have chosen a complex subject as your first database.

I am going to list a number of videos related to Customers, Orders, OrderItems and Products.
I'm sure these will help you.

Here are some documents and videos related to Database and Access. I hope you find them useful.

Principles of relational Design http://forums.aspfree.com/attachment...2&d=1201055452
Entity Relationship Diagramming http://www.rogersaccesslibrary.com/T...lationship.zip

These free video tutorials describe the processes of data modelling, normalization and entity relationship diagramming. There are other videos, but this group is by the same presenter and covers an example situation. The example relates Customers, Orders and Items.

http://www.youtube.com/watch?v=IiVq8M5DBkk Logical data modeling

http://www.youtube.com/watch?v=BGMwuOtRfqU Candidate key

http://www.youtube.com/watch?v=ZiB-BKCzS_I Normalization

http://www.youtube.com/watch?v=pJ47btpjAhA Normalization example

http://www.youtube.com/watch?v=q3Wg2fZENK0 1st Normal form

http://www.youtube.com/watch?v=vji0pfliHZI 2nd Normal form

http://www.youtube.com/watch?v=HH-QR7t-kMo 3rd Normal form

http://www.youtube.com/watch?v=q1GaaGHHAqM E_R Diagramming

http://www.youtube.com/watch?v=lXAGQ8vmhCY ERD Part 2

The first few topics at this site are well worth the read.

http://www.rogersaccesslibrary.com/forum/topic238.html

Good luck with your project.

Complete set of tutorials on Acc2010.
https://www.youtube.com/playlist?lis...FoilxbUY0yUqZP

a few things:
CustomerName text is not a good PK.
field names with special characters "#" is frowned upon and will lead to syntax errors

 

[RammerJammer1674]

I keep getting a Page Not Found whenever I click on a few of those links.

Do you mind modifying my database so I can sort of see a sample on how you did it?

Just something quick and simple. I'm not creating this database to sort of RUN the company or anything, just to simply help make my job a little easier.

Thanks!

PS - I'll change all of my special characters, thank you for the tip!

 

[jdraw]

I had an issue copying the links. I actually had to edit the first post and replace the links that for some reason did not appear as links.

Try the links now that they have been edited.

I am including a link to Rainlover's naming convention material. Well worth the read.

https://skydrive.live.com/?cid=cc4b03430dc41ca3&id=CC4B03430DC41CA3!145