I have
three linked tables that I want to enter data to using a single form. These tables
are:
tblMember –
which stores the details for a member. Its fields are id, firstname, surname
& occupation
tblMemberAddress
– which holds the addresses of members; home address, work address etc . Its
fields are memberID, housename, postcode, city & addresstype and
tblMemberGroup
– which holds the id of the group the member is assigned to.
I have managed
to use the wizard to create a form to enter details into all of these tables.
However, when I view the form in ‘view’ mode it shows a blank form. I suspect
that the form is not bound to any of the tables. How do I get the fields to be
displayed so I can enter data?
No one has replied yet! Why not be the first?
Sign in or Join us (it's free).