MANY years ago my first ever job was trainee Access DB developer.
Back then I was taught to use lookup fields in tables.
Today I know this is baaaad.
Is there an easy way to remove look up fileds from tables, fix the forms and update the data?
Is there a bset practice for putting this right.
Perfect example is a look up field for "location" that has 36 options. So if I remove the lookup field in the table all the locations become numbers across 6000 records...
Back then I was taught to use lookup fields in tables.
Today I know this is baaaad.
Is there an easy way to remove look up fileds from tables, fix the forms and update the data?
Is there a bset practice for putting this right.
Perfect example is a look up field for "location" that has 36 options. So if I remove the lookup field in the table all the locations become numbers across 6000 records...