Hi all,
Looking for a solution to my problem regarding my text box on my form returning a number instead of a value.
Below are my tables:
Raw Material
ID(KEY) Raw Material CAS No. Primary Supplier Suppliers 1 Apple 001 Laura Laura 2 Orange 002 Mike Laura, Mike 3 Strawberry 003 Ryan Laura, Mike, Ryan
Primary Supplier is a lookup to the table Supplier and Suppliers is a lookup with multiple values to the table Supplier
Supplier
ID(KEY) Supplier 1 Laura 2 Mike 3 Ryan
I then do the exact steps:
Create Blank Form - Combo Box - Table:Raw Material - Selected Fields: ID, Raw Material, CAS No, Primary Supplier, Suppliers.
Properties of the Combo Box - Change the column widths to "0cm;2.542cm;0cm;0cm;0cm" so it hides all except Raw Material. Change list width to auto.
Combo box source: SELECT [Raw Material].[ID], [Raw Material].[Raw Material], [Raw Material].[CAS No], [Raw Material].[Primary Supplier], [Raw Material].[Suppliers] FROM [Raw Material];
Insert text box, change source to =[Combo9].[column](2) <--- This to show the CAS No
Insert text box, change source to =[Combo9].[column](3) <--- This to show the Primary Supplier
Insert text box, change source to =[Combo9].[column](4) <--- This to show the full list of Suppliers.
However the Primary Supplier for Orange for example shows 2 instead of Mike and the Supplier List shows up as 1,2 instead of Laura, Mike.
My question is how can I can stop it showing up as the number id associated and instead as the Name.
Thanks,
Mike