This is a follow up to my previous question. The code below will grab the column names and put them in a table. Question I have is can I do something similar where the table in a grid several of the fields are based on a lookup and when I enter the field in a grid the drop down would show the column names from the other table. Is that possible.
dim rs1 as dao.recordset, rs2 as dao.recordset, j as integer
for j=0 to rs1.Fields.count-1