anyway I can use dlookup in access 2k from the table design view ?

  • Thread starter Thread starter Keith Handley
  • Start date Start date
K

Keith Handley

Basically what I want is a drop down based on a subselect based on the value
of a just entered field data

Its a doddle using forms but I cant use forms in this case (dont ask its a
long story)

Basically I have 2 tables

Table1
ReportName text
ReportID text

Table2
GenDesc text
ReportName text
ReportID text

I have a lookup defined for a select Reportname from table1 defined for the
lookup for table2.Reportname That works fine but When entered I want to
default the Table2.reportID to the reportID that matches the Reportname from
Table1

Thanks for any ideas

Keith
 
Back
Top