How do I...Create Forms based on Relationship

[mspeppa19]

I have the following tables as listed below, and I am having trouble creating my forms properly. The issue is that The Purchase Table is I guess the "connector" for all of the other tables. The program I am trying to create is for my mom's business who wants to have a basic tracking program of all of her purchases. Since the purchase table is the "connector" when I go to set-up my forms what should be used to allow the business to enter data? Right now, when I create the forms something is always messed up. If I include all of the information from the Purchase Table am I supposed to also include those primary key's from the related tables too? The PKs in the purchase table are autonumbers, and the PKs in the related tables are just numbers (so everything is based off of purchase table...do I need to swithc this?)

I just need a little help understanding how I go about creating my main form so that the business can add a new purchase ID, complete with one vendor, and how many ever products was purchased on that date from that vendor. I've been trying to figure this out for a week now and nothing seems to be working. I even tried making everying based on a query. So, when creating my forms, what table information goes where? (or what kind of relationships when using either the form wizard or the query should I try?) Thanks.

business table: 1 to M relationship w/ purchase table (one
business can have many purchases)
tblBusnID*
tblBusnName

purchase table: THE CONNECTOR (one purchase table can have
one business: one purchase table can have
many products: one purchase table can have
one vendor)
tblPurchID
tblBusnID*
tblVenID*
tblProdID*

vendor table: 1 to M relationship w/ purchase table (one
vendor can have many purchase orders)
tblVenID*
tblVenName

product table: M to 1 relationship w/ purchase table (one
purchase table can have many products from
one vendor)

tblProdID*
tblProdName

 

[PaulF]

You might want to checkout the Northwind database that comes with Access, it will lead you in the right direction.

PaulF

 

[mspeppa19]

I tried the northwind, but I'm still not sure how I should relate the tables? Does anyone have any ideas?

 

[rccline]

Paul:

I think the Customer Orders form in the Northwind Database demonstrates what you are looking for. I am working on a similar problem myself trying to track: Contracts, Sellers and Buyers, where there may be multiple sellers and buyers, Sellers and buyers may be listed on multiple contracts. I have not been able to duplicate the NW-Customer Orders form using my own database, but I think this represents the path to solution. I'm still lost myself and despirately looking for some direction.

Robert