Cynw,
Let's start from the beginning why did *whoever* think families should be
segregated from individual member? My better way is put them back into one
table and use a field to indicate if it is an individual. Any if *whoever*
wants to see all the individuals you can run a query based on the before
mentioned field.
--
Gina Whipp
2010 Microsoft MVP (Access)
"I feel I have been denied critical, need to know, information!" - Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
"Cynw" wrote in message
...
At present I have a membership database with all members held in one
table. I
have been asked to split this table into two tables - family and
individual
members. The user still wants to view all the records in both tables using
the same form as at present. However if I use a UNION query on the two
tables
and link the form to this query, I have found that although I can view all
the records from both tables, I now cannot update them.
Any advice on a better way to design and link the tables would be
appreciated.