Choosing Certain Information for forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table for shareholders called Contacts which holds their
names/addresses etc. However, some of the shareholders have more than one
address and this information is held in another table called Abroad. I have
created a form using the tab control which shows their name and address,
address abroad, private info, etc. I was wondering if there is a way of
having one address tab and in that tab allowing me to pick either the address
at home or abroad.

Your help would me much appreciated.

emc
 
Emc,

Any chance of a change to the table design? I would put addresses in a
separate table, with an additional field added for AddressType (i.e.
main, abroad, anything else). This would make it a lot easier to do
what you want.
 
Steve,

I’m afraid my brain is working this morning and don’t really understand what
you mean. Do I make the separate field of AddressType in the Addresses table
a combo box with a row source?

emc
 
Emc,

Let's say your Contacts table is like this...

ContactID
ContactName
Phone
... anything else

And the Addresses table is like this...
AddressID
ContactID (foreign key to join to Contacts)
Address
AddressType

That means you can enter more than one address for each contact. As
regards your form, you would use a continuous view subform based on the
Addresses table. And yes, probably using a combobox for the entry of
the AddressType would be good - I suppose it would give choices of
"Main" and "Abroad", or some such, unless you needed other options such
as "Postal", "Shipping", whatever.
 
Back
Top