I have a table that shows a list of vendors that participate in a medical conference. Their Vendor ID is an auto number and is the primary key. Another table consists of conference data. The primary key here is the "year_VendorID" So 2009_1, 2009_2, 2010_18, etc. So the first form shows vendor "1" and the information for 2009. The next form would be vendor "1" and info from 2010. I want each vendor to have only one form with the conference data for every year on it. I'm very new to access and trying to learn it on the fly here. Sorry if this is a simple question or if I did a poor job of explaning my situation. Any help would be greatly appreciated. Thank you!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access Forms. 1
- Thread starter schreima
- Start date
-
1
- #2
The year and the vendorID should be in two separate fields. I would create an autonumber primary key on the conference data. You could create a unique index on the ConferenceYear and VendorID field combination.
A simple subform on of conference data on a main form of the vendor information should work well.
Duane
Hook'D on Access
MS Access MVP
A simple subform on of conference data on a main form of the vendor information should work well.
Duane
Hook'D on Access
MS Access MVP
- Status