Forum Discussion
soufiane91
Feb 05, 2021Copper Contributor
show names instead ID
Hi , How to show names instead of ID , I have a query used in two forms that contain a filed's row source is a query . So in the first form it's Okay it shows names but in the seconde form shows ID...
soufiane91
Feb 07, 2021Copper Contributor
George_Hepworth
Feb 07, 2021Silver Contributor
soufiane91 I think the solution is, as I said before, to include the table which DOES have the client name field in it as part of the query for the list box. Display that client name field in the list box instead of the Foreign Key (i.e. the ID) field.