thank you for a quick explanation on my last question.
This one may be even more simple, but again I can't find an answer...
I have a form used to enter donations for a charity. Everything works to populate the table Donations, but it is creating a new record on each lookup table rather than looking for value in the field. It is using the value to populate the combobox, but once selected, it creates a new value in the lookup table.
please help.
update: I found this Field list. This may be what is causing my issue, but I'm not sure how to fix it. The fields under 'Fields available for this view:' duplicate entries on the lookup tables. The fields under 'Fields available in related tables:' does not duplicate. So how do I get these other lookup tables to appear in the 2nd list?
thanks,
Brian