J
jcinn(cylvia)
I am using Access 2003 and want to combine/join the fields from two tables
because all the fields will be searched at one time or another. I received
an error message (too many fields) when I tried to join these fields via a
form for so that we could easily do a search. Compacting the data didn't
remedy the problem. All I want to do is combine the data into one table so
that we can easily search by a field name.
Fields Table 1
1. Acct Mgr
2. Group name
3. Group #
4. Product
5. Rx
6. Vision
7. MHSA
8. Chiro
9. RA
10.Subs
11.Mbrs
12.Status
13.Comments
14.New Grp#
15.New Plan
16.Broker
Fields Table 2
1. Status
2 Group Name
3. GA
4. Broker
5. Broker 2
6. AE
7. AM
8. Eff Date
9. EE
10.Subs
11.Mbrs
12. HMO
13.POS
14.PPO
15.Ra/No PPI
16.UW Load
17.Group’s Email
18.Group’s Fax
19.County
because all the fields will be searched at one time or another. I received
an error message (too many fields) when I tried to join these fields via a
form for so that we could easily do a search. Compacting the data didn't
remedy the problem. All I want to do is combine the data into one table so
that we can easily search by a field name.
Fields Table 1
1. Acct Mgr
2. Group name
3. Group #
4. Product
5. Rx
6. Vision
7. MHSA
8. Chiro
9. RA
10.Subs
11.Mbrs
12.Status
13.Comments
14.New Grp#
15.New Plan
16.Broker
Fields Table 2
1. Status
2 Group Name
3. GA
4. Broker
5. Broker 2
6. AE
7. AM
8. Eff Date
9. EE
10.Subs
11.Mbrs
12. HMO
13.POS
14.PPO
15.Ra/No PPI
16.UW Load
17.Group’s Email
18.Group’s Fax
19.County