I'm in a mess![UIDs]

[Elmobram22]

I have finished a database with very little knowledge and just learnt as I have gone on via youtube etc. Trouble is the first thing I learnt was from someone who didn't know. I followed their instructions for using the lookup wizard and rather than point to the ID I pointed to the name. I only noticed this at the end when I came to do a selection query. Is there an easy way to rectify this? All the fields have the IDs its just I need all the forms to go off the UIDs and show the text. I have tried to change it a bit but it kind of cascades through the database to show just numbers or stop forms from working etc. I can upload the file if necessary.

Thanks

Paul

 

[Mihail]

What is the table in trouble ? What field ?
In what form is showed this field ?

 

[Elmobram22]

Nice one Pat. It took me a while to truly understand what you meant but then the penny dropped! I ended up habing to go through and change all the sql statements as they were working off the old queries that did not use the ID and only the name. Eventually got it working and now it is great. Cheers!!