Microsoft Access Relations Ships and Forms

[rajgoyal00]

I am struggling to make this happen and cant seem to get anywhere. Hopefully Someone here can help me.

I am creating a database for a retail store.

- I have a table (Vendor List) that stores information about my vendors (Fields: ID (PrimaryKey), DataVal(DateVendor Added), Vendor Name(Text), Address(text), and so on).

- I have a table (Purchases) to enter my purchases on a particular date for Vendors and the amount so (Fields: ID(Primary Key), DateVal(date), Vendor Name, Amount)

What I want to do is create a form with a purchase date, (Combo Box) to choose a vendor from a drop down list (Vendor Name from table Vendor list) and enter an amount for the particular vendor and a description field for that purchase from that vendor. I want to have multiple entries for that date (as many vendors can supply on one day) on the same form.
How is that possible. I am new to access and don't know much about setting up relationships. Any help will be appreciated. I can also be emailed at rajgoyal00@gmail.com.

[RuralGuy]

I would start by naming your ID fields something useful like VendorID and PurchaseID. Then your Purchases table should have the VendorID rather than the VendorName. That is your 1:m relationship.

[rajgoyal00]

I would start by naming your ID fields something useful like VendorID and PurchaseID. Then your Purchases table should have the VendorID rather than the VendorName. That is your 1:m relationship.

Thanks for your reply. I actually had done that. But the composition of the relation ship is still an issue. morely, when we are in a form we will using a vendor name rather than remembring the vendor no. (AGAIN SORRY, if my questions are sounding stupid) I started using access 3 days go and have spent over 20 hours on it. I have created many forms and tables, just got stuck with this one issue)
Thank You for your reply

[RuralGuy]

Once you put that ForeignKey in the Purchases table the two tables can be joined in a query on that field and then all of the fields in both tables can be displayed as if they are in one table.

[rajgoyal00]

So this is what I did. I didn't touch the ID (primary key) and made a field in each table vendor id. I set a relationship as you suggested. (Makes Sense).
Then I went to create a query and I chose DateVal from purchase table(since thats the date we will be entering) and Vendors name from vendor list table, and amount and description from purchases table.

Displayed query table with all the fields, but now when i want to enter in dateval it just beeps and does nothing, or any other field except vendor name. What is it that I am not doing rt or understanding. Thanks

[rajgoyal00]

What I am trying to do is create a form use for vendor purchases.

type in a date
choose vendor name
enter the amount
and a desc

choose another vendor name if there is
and once I am done, close and save

[RuralGuy]

Displayed query table with all the fields, but now when i want to enter in dateval it just beeps and does nothing, or any other field except vendor name. What is it that I am not doing rt or understanding. Thanks

This link may contain the answer to this question: http://allenbrowne.com/ser-61.html