I created a form for a table joined many-to-one with another table. The one table contains organization members, and the many table contains dues payments and charges. The SQL for the form is
Code: Select all
SELECT dues.*, member.lastName, member.firstName
FROM dues, member
WHERE dues.member_fk = member.member_id
ORDER BY dues.date DESC
This works fine on the browse form, correctly displaying the last name and first name with each member dues entry. However, when I create objects on the edit form for lastName and firstName, they aren't populated. It's strange, because I've used the exact same technique to create a subform, and it worked fine.
Any advice appreciated!
Thanks,
Gib