I'm a newbie who went ahead and designed my tables with lookup fields because I didn't know any better until I couldn't get the results I wanted in my report. I am now in on the secret--they ARE evil.
The good news: this DB hasn't been published, I'm very much open to going back and removing/converting those lookup fields, but I'm not sure the best way to attack it?
I'm working in Access 2010. This is essentially an HR database intended to track training and job postings. I used a lookup in my Postings table to identify type of posting, eg. incumbent, relief1, relief2. I want to print a report that lists employees down the left and shows their posted positions under the relevant "type."
How do I let the Postings table know that the field is no longer a lookup field and how do I replace the data? From what I've been reading, I think I want to set up a LookUp table with those three "types" and relate it back to that table, entering the data against the employee through forms via a combo box. If that sounds right, I can muddle through that part, but still not sure how best to remove the data that is there.
If anyone is willing to point me in the right direction I'd be eternally grateful. Keep in mind that my entire education in Access has been driven by Google and the book my boss handed me titled "Access '97". I'm doing pretty well, but am still very new and need simple instructions, not code unless it's screamingly easy.
And of course if this topic has been covered extensively elsewhere, please point me to the appropriate thread.
Much appreciated,
Dani