Problem with Lookup Fields..

Question

So I have a table [Applicants] that has a lookup field [Scholarship Name] that pulls a list of scholarships from the [Scholarship] table. It works fine and dandy, and was a suggestion from a user on this forum..

My problem is, users also suggested keeping one [Applicant] table instead of one for each year to eliminate duplicates, etc. This involves importing my applicant data each year and then appending it to the [Applicant] table, which you cannot do if there is a lookup field in that table... Any suggestions on what to do??

Thanks!

---

Mandy Jo

Answer 1

Do not use lookup fields in the table but use combo on form with lookup table as source.

Answer 2

I remember the thread.  I think I'm the one who suggested this to you (one table with a year (or date field), but not to use a lookup field; it was to use a related table and a combo box to do the look up.  Sorry for any confusion.

---

For the benefit of others, please mark posts as answered or helpful when they answer or assist you in finding the answer. ___ "We came all this way to explore the Moon, and the most important thing is that we discovered the Earth." - Bill Anders, Apollo 8.

Answer 3

Thanks! Not sure why I didn't make that connection in my brain!

---

Mandy Jo