How can I create a display only form in MS Access to display all the rows in a table, with one of the fields being a combo box so the result would be:
PartNo - Description - Products(Combo)
For the Products(Combo), I wanted to specify the source as an SQL Query that displays all the Products associated with the PartNo (in that row)
I would need to refer to the field in that particular row somehow in the SQL statement but I cant work out how to specify it.
Anyone know the best way to achieve this ?