View Single Post
  #3  
Old January 8th, 2010, 11:30 AM posted to microsoft.public.access.tablesdbdesign
Cynw
external usenet poster
 
Posts: 2
Default Updating two identical formatted tables with one form

The individual members already have a field that is set to "yes" in the
present table. I work for a charity and the committee want the Individual
members to be held in a seperate table. People in the office need to be able
to look at information about members and do this via a form which displays
all the details of a member. However as they do not know if the enquiry is
about a family member or an individual member, we need to display all members
using the same form. Hope that make my design problem easier to understand.
Thanks.

"Gina Whipp" wrote:

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.



.