populating a form based on another (non-related) table

  • Thread starter Thread starter CJG via AccessMonster.com
  • Start date Start date
C

CJG via AccessMonster.com

Hi!

I have a form for a user to add new point events if needed. The table behind
it is not populated with data. I need to autopopluate a field in this form
based on a table NOT related to it ....i.e. my "site" field should populate
for each new point event added from a different table with the "site" field.
I've tried attaching an update or append query to an event on my form,
however since these are new records and are not in any of the tables, the
joining won't/doesn't work because there is no relationship....does this make
sense? If this shouldn't be handled in a form, where should it be handled
and how?

Thanks in advance,
cjg
 
Back
Top