AutoLookup

[Michael Clifford]

I'm going nuts about this:

I'd like to have the end user enter an id from a lookup table and have it
pull all the other values (name, title) related to this into another table.
Ideally, the id and other descriptive info from the lookup table should be
pulled down so that the end user has more than the ID to make a decision.

I've looked at the help on "Create an AutoLookup query" and "About
AutoLookup queries that automatically fill in data" and tried every
combination for over 18 hours with no luck. The ancillary fields don't get
filled in. Moreover, there seems to be zero on this on the Net.

All conditions (many-to-one, indexes) seem to be met. I'm missing some small
setting not documented in the *##*#* help on this subject.

Again, I'd like to do this at the table level and not have to resort to
reams of dialog box coding.

Any help is appreciated.

Thanks,

Michael

 

[Tim Ferguson]

I'd like to have the end user enter an id from a lookup table and have
it pull all the other values (name, title) related to this into
another table.

Bad Mistake -- that's not what databases are made to do.

Put the ID in the table, and then use a query to see the associated
records.

You might like to do some reading round Relational Theory, normalising
tables, etc.

B Wishes


Tim F