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

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.