View Single Post
  #1  
Old January 7th, 2010, 04:28 PM posted to microsoft.public.access.tablesdbdesign
Cynw
external usenet poster
 
Posts: 2
Default Updating two identical formatted tables with one form

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.