19 เมษายน 2555 15:25
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??
19 เมษายน 2555 16:21Do not use lookup fields in the table but use combo on form with lookup table as source.
19 เมษายน 2555 17:30I 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.
19 เมษายน 2555 17:42
Thanks! Not sure why I didn't make that connection in my brain!