Hi
I have included a sample of the problem I am encountering.
I have a look up table but it is defaulting to a number when I select it.
I have asked this question before and people have said dont use look up tables. This is fine but I do not know what do use as an alternative.
This maybe something really simple.
Anyway in the example I want it to be created in table 1 (Database) which works.
I then want it to pull through into table 2 (Make Live) which works
Then on table 3 (book course) I want it to pull through the course name from the "Make Live" table.
I can see that on the table 2 (Make Live) it has already defaulted to number.
Whatever I do it will always default to number. I have deleted the relationships and restarted.
Any help would be appreciated on this frustrating but I am sure simple problem.
Many thanks in advance
Rachel Trial1.accdb